9. Cool Tricks New with PowerPivot

In This Chapter

Building a Report with Two Pivot Charts 200

Adding Slicers and Understanding Slicer AutoLayout 203

Adding a Pivot Chart to an Existing Layout 208

Adding a Pivot Table to an Existing Layout 212

The PowerPivot add-in enables you to build multiple pivot table elements on one worksheet that are all controlled by the same set of slicers.

This is just your run-of-the-mill pivot table and pivot chart that have been moved to be adjacent to each other. You can build pivot charts that show different summaries and have them all respond to a single set of slicers.

The PowerPivot add-in has a drop-down that offers eight layouts. You’ve already seen the single pivot table, single pivot chart, and flattened ...

Get PowerPivot for the Data Analyst: Microsoft 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