MS-Excel / General Formatting

PivotCharts Extend PivotTables

Microsoft introduced PivotCharts in Excel 2000. In an instant, you can create interactive charts that were previously impossible without using either VBA or Excel Controls. PivotCharts are created from PivotTables, so a PivotChart shows graphically a representation of your PivotTable. PivotCharts work very similarly to the standard Excel charts, and most of the features are available. The beauty of PivotCharts and PivotTables is that they are interactive with each other-change something in one, and it will also be reflected in the other.

PivotCharts are not available in Excel for the Macintosh.

[Previous] [Contents] [Next]

In this tutorial:

  1. Excel Pivot Tables
  2. Why Are They Called PivotTables
  3. What Are PivotTables Good For
  4. PivotCharts Extend PivotTables
  5. Creating Tables and Lists for Use in PivotTables
  6. PivotTable Creation
  7. Share PivotTables but Not Their Data
  8. Automate PivotTable Creation
  9. PivotTable Save Time with a Macro
  10. Move PivotTable Grand Totals
  11. Efficiently Pivot Another Workbook's Data