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

Creating PivotCharts

Figures 24.21 and 24.22 show data structured with the same criteria as a PivotTable versus a PivotChart. When a PivotChart is created, Excel creates both a chart sheet and a PivotTable sheet within the workbook; because the chart information must be derived from a table, Excel automatically creates the table. The default action of the PivotChart feature is to create a chart as a worksheet, but you also can create an embedded chart on a worksheet in the last step of the PivotTable Wizard or by choosing Chart, Location and selecting the As Object In option after creating the PivotChart.

Figure 24.21. This PivotTable is based on a structured list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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