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

Improve your Excel dashboards by adding in dynamic charts that allow the user to control what they want to see. Link to complete course: https://courses.xelplus.com/p/professional-excel-dashboards 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 formula is a great alternative to the OFFSET function AND it's not a volatile function. Once we've figured out the right INDEX formula, we will copy and paste this into name manager and use the name for our chart range. This will provide us with a dynamic chart that only shows the user the range they'd like to view. More Index Match videos: Basics of Index Match: https://youtu.be/F264FpBDX28 Advanced Index Match: https://youtu.be/ontXHp9cwOQ Index Dynamic Ranges: https://youtu.be/YBehCWjcizg ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel