O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

1.
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.
2.
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required