Cross filter visuals in Excel | Amazing interactive charts | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Check out the blog post★
https://exceloffthegrid.com/cross-fil...

★ About this video ★
Power BI has a really nice way of cross-filtering visuals. When you click on a visual, it highlights the selected item in other charts, while also retaining the total value in a lighter color. Can we cross filter visuals in Excel? No. But we can create something pretty close.

0:00 Introduction
0:25 Data
1:16 Calculations
5:38 Create the charts
6:27 Create the slicers
7:40 Formatting and presentation
15:30 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel