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 ...

Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.