6. Using Pivot Charts and Other Visualizations

In This Chapter

What Is a Pivot Chart...Really?

Creating a Pivot Chart

Keeping Pivot Chart Rules in Mind

Examining Alternatives to Using Pivot Charts

Using Conditional Formatting with Pivot Tables

Creating 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 ...

Get Excel® 2016 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.

Start your free trial