Chapter 35: Analyzing Data with Pivot Tables
735
FIGURE 35.23
After expanding the pivot table, formulas that use the GETPIVOTDATA function continue to display the
correct result.
Creating Pivot Charts
A pivot chart is a graphical representation of a data summary displayed in a pivot table. A pivot
chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart
at the same time, you can’t create a pivot chart without a pivot table.
If you’re familiar with creating charts in Excel, you’ll have no problem creating and customizing
pivot charts. All Excel charting features are available in a pivot chart.
Cross-Reference
I cover charting in Chapters 18 and 19. n
Excel provides two ways to create a pivot chart:
l Select any cell in an existing pivot table and then choose PivotTable Tools ➪ Options ➪
Tools ➪ PivotChart.
l Choose Insert ➪ Tables ➪ Pivot Table ➪ Pivot Chart. Excel creates a pivot table and a
pivot chart.