Data Analysis with Excel 📈📉📊✅ - Link up two charts to the same slicer - AMAZING Excel Trick 💡

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 - https://skl.sh/2YrM5dU As a standalone download - https://chandoo.org/wp/modern-excel-dashboards-mini-course/ 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 - https://chandoo.org/wp/wp-content/uploads/2021/12/amazing-dashboard-trick.xlsx Watch next... 📽 ============= My one hour Excel Dashboards Course - https://skl.sh/2YrM5dU How to use Excel Slicers - https://youtu.be/ZZ-UGMztoqo More Excel Dashboard Tricks & Examples (Playlist) - https://youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT Thank you and have a beautiful day 😀🌼🌞