Creating a Chart

Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.

The Chart toolbar

Excel 2000 offers several ways to work with charts. The quickest way to create and edit your charts is to use the Chart toolbar.

To show the Chart toolbar:

  • Choose View Toolbars Chart.

view menu

Parts of the Chart toolbar:

chart toolbar

Chart Objects list box

This allows you to select the individual parts of your chart.

Format button

This allows you to format the current selection.

Chart type

Use this to select the type of chart.

Legend

Show or hide the chart legend.

Data table

Show or hide the actual data used to create the chart.

By row

This displays the y axis using row labels.

By column

This displays the x axis using column labels.

Angle text

Use these to change the angle of the x and y axis labels.