How to show hidden data in an Excel chart | 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/using-hid...
★ About this video ★
Imagine you’ve created a beautiful chart for your Excel report. You decide to hide the source data because the users don’t need to see it. Suddenly the information in the chart disappears. So, this raises the question: how to show hidden data in an Excel chart?
We answer this question in this video. But, we go further. We also look at how we can use this technique for more advanced user interactivity.
0:00 Introduction
0:35 Showing hidden data in a chart
2:12 Creating dynamic charts
3:47 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