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

Creating PivotCharts

Figures 20.23 and 20.24 show data that's 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 selecting Location from the Chart menu and selecting the As Object In option after creating the PivotChart.

Figure 20.25 shows the difference between a PivotTable and a PivotChart: An embedded PivotChart has been formatted and placed on the same sheet as a formatted PivotTable. (Figure 20.26 shows the same worksheet, posted to a Web page. See the later section "Saving and Editing PivotTables in HTML Format" for details.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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