Creating a Chart

You can create charts as part of a worksheet (an embedded chart) or as a chart on a separate worksheet. If you create an embedded chart, it will print side-by-side with your worksheet data. If you create a chart on a separate worksheet, you can print it independently. Both types of charts are linked to the worksheet data that they represent, so when you change the data, the chart is automatically updated.

The Chart Wizard button in the Standard toolbar enables you to quickly create a chart. To use the Chart Wizard, follow these steps:

  1. Select the data you want to chart. If you typed names or other labels (such as Qtr 1, Qtr 2, and so on) and you want them included in the chart, make sure you select them.

  2. Click the Chart Wizard ...

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.