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 ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours 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.
