• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Using PivotTables and PivotC... > Creating and Editing PivotCharts

Creating and Editing PivotCharts

A PivotChart is a chart based on data in a PivotTable. Like its row-and-column-based counterpart, you can rearrange a PivotChart by dragging field labels on a chart sheet. When you change the layout of a PivotChart, Excel automatically rearranges the corresponding data in your PivotTable, and vice versa.

PivotCharts were introduced in Excel 2000, and they're a welcome addition. In general, anytime you can use a PivotChart instead of a conventional chart, you should jump at the opportunity, because they're so much easier to create and edit.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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