Chapter 6
Working with PivotCharts
In This Chapter
Why in the world would you use a pivot chart?
Running the PivotChart Wizard
Fooling around with your pivot chart
Customizing how pivot charts work and look
In Chapter 4, I discuss how cool it is that Excel easily cross-tabulates data in pivot tables. In this chapter, I cover a closely related topic: how to cross-tabulate data in pivot charts.
You might notice some suspiciously similar material in this chapter compared with Chapter 4. But that’s all right. The steps for creating a pivot chart closely resemble those that you take to create a pivot table.
If you’ve just read the preceding paragraphs and find yourself thinking, “Hmmm. Cross-tabulate is a familiar-sounding word, but I can’t quite put my finger on what it means,” you might want to first peruse Chapter 4. Let me also say that, as is the case when constructing pivot tables, you build pivot charts by using data stored in an Excel table. Therefore, you should also know what ...
Get Excel Data Analysis For Dummies, 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.
