Chapter 9. Creating a PivotChart
Understanding PivotChart Limitations
A PivotChart is a graphical representation of the values in a PivotTable report. However, a PivotChart goes far beyond a regular chart because a PivotChart comes with many of the same capabilities as a PivotTable. These capabilities include moving fields from one area of the chart to another, hiding items, filtering data via the page field, refreshing the PivotChart to account for changes in the underlying data, and more. You also have access to most of Excel's regular charting capabilities, so PivotCharts are a powerful addition to your data analysis toolkit.
However, PivotCharts are not a perfect solution. Excel has fairly rigid rules for which parts of a PivotTable report correspond ...