Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads