Control all Pivot Tables and Charts at once

Please purchase the course before starting the lesson.

Using slicers, it is possible to control multiple Pivot Tables and Pivot Charts at the same time. This is useful when you are setting up a dashboard and you want o create multiple reports and charts but they must all change together when you choose an option.

In this lesson you will learn

  • How to link Pivot tables and charts via a slicer
  • How you can set up a slicer on each page and the main page, and the slicers will be interchangeable and you can click on any one of them to change all Pivots.

To see the full course contents click here.

Back to: Intermediate Excel Course > Pivot Tables