7. Creating and Using Pivot Charts
In this Chapter
What Is a Pivot Chart Really? 123
Creating Your First Pivot Chart 123
Rules and Limitations of Pivot Charts 126
Alternatives to Using Pivot Charts 135
What Is a Pivot Chart Really?
A common definition of pivot chart is a graphical representation of the data in your pivot table. Although this definition is technically correct, it somehow misses the mark on what a pivot chart truly does.
When you create a standard chart from data that is not 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. ...
Get Pivot Table Data Crunching 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.
