Here is a super quick and AWESOME way to enhance your dashboards. Use a single slicer to control all the charts. Just set up the charts (from pivots) and add a slicer. Make sure that the slicer is linked to all pivot tables and you are done.

GET the Excel Dashboard Course 💻💥
================================
Via Skillshare - [ Ссылка ]
As a standalone download - [ Ссылка ]


In this video ⏱👉
==============
0:00 - Quick demo of one slicer & two charts
0:24 - Adding the pivot tables
0:55 - Inserting the first chart & formatting it
1:52 - Adding the second chart
2:36 - Moving the charts to dashboard worksheet
2:58 - Adding a slicer
3:25 - Connecting slicer to both charts
4:05 - One more DASHBOARD TRICK ⚡

Sample file 📗👉
=============
If you need an example workbook to test this concept, get it here - [ Ссылка ]

Watch next... 📽
=============
My one hour Excel Dashboards Course - [ Ссылка ]
How to use Excel Slicers - [ Ссылка ]
More Excel Dashboard Tricks & Examples (Playlist) - [ Ссылка ]

Thank you and have a beautiful day 😀🌼🌞

свернуть