From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Applying slicers to multiple charts

Applying slicers to multiple charts - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Applying slicers to multiple charts

“

- [Instructor] So like we talked about back in section four of the course, slicers and timelines are essentially just user-friendly, interactive filters that you can layer onto a pivot table. Now, they work exactly the same way in the context of pivot charts, they'll just be connected to both the table and the chart. But in this video, we're going to take things to the next level and create slicers and timelines that can be assigned to multiple pivots and multiple pivot charts at once. And what that means is that a single filter can be used to update an entire collection of pivot tables and charts, which, as we'll cover in the next lecture, is an incredibly easy way to build really nice, dynamic dashboards. So here's how it's done: step one is to select the pivot chart that you want to add a slicer or timeline to, and keep in mind that it really doesn't matter which one you start with if you eventually want all of your charts to be connected. So in this case, let's select our first…

Contents