• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 and column fields appear as the category and value axes of the chart, respectively.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint