Chapter 7. 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 hiding items, filtering data via the report filter, refreshing the PivotChart to account for changes in the underlying data, and more. Also, if you move fields from one area of the PivotTable to another, the PivotChart changes accordingly. 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 ...