About this tutorial:
Video duration: 00:12:25
Improve your Excel dashboards by adding in dynamic charts that allow the user to control what they want to see.
Link to complete course:
Downloadable workbook available inside the course.
In this lecture you will learn how to create a dynamic chart ranges – assume your raw data table is quite big and you’d like the user to specify from which category or date – and to which category & date, they’d like to view the chart data from.
Excel Offset function is one formula that you can use to create dynamic ranges, but Excel’s Index…