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