Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 6. Using 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 people to make split-second determinations about what the data is actually revealing. Charts offer instant gratification, allowing people to immediately see relationships, point out ...