Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 6Using pivot charts and other visualizations

In this chapter, you will:

• Learn about pivot charts

• Create a pivot chart

• Keep pivot chart rules in mind

• Examine alternatives to using pivot charts

• Use conditional formatting with pivot tables

• Create custom conditional formatting rules

What is a pivot chart…really?

When sharing your analyses with others, you will quickly find that there is no getting around the fact that people want charts. Pivot tables are nice, but they show a lot of pesky numbers that take time to absorb. Charts, on the other hand, enable users to make split-second determinations about what the data is actually revealing. Charts offer instant gratification, allowing users to immediately see relationships, point out differences, ...