Chapter 15: Using Pivot Charts
In This Chapter
• Creating your first pivot chart
• Understanding the link between pivot charts and pivot tables
• Using conditional formatting with pivot tables
• Examining alternatives to using 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. 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 are actually a completely different animal.
The discussion here assumes that you’re familiar with the inner workings of pivot tables, which is covered in Chapter 14. Feel free to refer to Chapter 14 if you need a refresher on pivot tables.
Getting Started with Pivot Charts
When you create a standard chart from data that isn’t in a pivot table, you feed the chart a range made up of individual cells holding individual pieces of data. Each cell is an individual object with its own piece of data, so your chart treats each cell as an individual data point, charting each one separately.
However, the data in your pivot table is part of a larger object. The pieces of data you see ...
Get Excel Dashboards and Reports, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.