Building a PivotChart

A PivotChart is basically a column chart (by default) that is based on the data in a pivot table. You can change the chart to a different chart type if desired.

The next To Do exercise creates a PivotChart from an Excel list. You need to use the Excel list you created on Sheet2 earlier in this hour.

To Do: Build a PivotChart

Click the Sheet3 tab and click any cell in the Excel list. This step tells Excel that you want to use the data in the Excel list to create a PivotChart.
Choose Data, PivotTable and PivotChart Report. If the Office Assistant asks whether you want help with pivot tables, choose No. The PivotTable and PivotChart Wizard—Step 1 of 3 dialog box opens. From this point, until the PivotChart appears in ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.