vert line

First, select the range on the worksheet that you want to chart. If the range includes labels at the left and the top, then these labels will be used as the X and Y axis labels on the chart.

Then click the Chart Icon on the Workbook Toolbar (or use select Tools->Charts from the menu).

The Chart Selection Panel will appear. There are three main Chart Types (Bar, Line and Area). Within each Type there are several variations: for example a Bar Chart can be Stacked, Horizontal, 3D and more.

Click on the Type you want. The Chart will draw itself on the worksheet at the current cursor position. The Chart Inspector will also appear.

Use the Chart Inspector to change and customize the chart.

You can have as many charts as you like on the worksheet

You can move and resize charts.

See also

Also go to:

Index help

Contents help