Chapter 8. Using Pivot Charts
In This Chapter
Creating a pivot chart from a pivot table
Specifying pivot chart commands
Adding Excel's new slicers feature
Viewing pivot chart examples
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. Excel lets you create a pivot table and a pivot chart at the same time, but you can't create a pivot chart without a pivot table.
Getting Started with Pivot Charts
If you're familiar with creating charts in Excel, you'll have no problem creating and customizing pivot charts. Most of Excel's charting features are available in a pivot chart. But, as you'll see, pivot charts enable a few extra tricks — most notably, the ability to filter the data that's displayed.
For an introduction to Excel chart basics, refer to Part II.
Creating a pivot chart
Excel provides three ways to create a pivot chart:
Select any cell in an existing pivot table and choose PivotTable Tools
Select any cell in an existing pivot table and select a chart type from the Insert
A pivot chart cannot be a ...