Excel 2010 Bible

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.