O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required