Microsoft® Office Excel 2003 Inside Out

Creating a PivotChart

You can create a PivotChart by using the PivotTable And PivotChart Wizard (see Figure 30-4). Or you can first create a PivotTable and then, while any cell in the table is selected, click the Chart Wizard button on the PivotTable toolbar. If you take the first approach, Excel creates both a new PivotTable and a new PivotChart. If you take the second approach, Excel creates a PivotChart based on the current PivotTable.

Either way, the chart and table are linked. Changes to one are reflected in the other. Figure 30-10 shows a PivotChart that's linked to the PivotTable shown in Figure 30-9. Notice that the page fields of the PivotTable shown in Figure 30-9 appear at the upper left corner of the PivotChart, and the table's row ...