Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards
Jul 6, 2017 Excel Dashboards & Reports
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
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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
-
15:07
CartierFamily
1 day agoRepublican CALMLY DISMANTLES CNN Host Over GOP Denied Bill! 🔥
23.8K55 -
20:10
Degenerate Jay
4 hours agoThe PlayStation 5 Pro Is Bad News For Gaming
18.7K5 -
11:47
Colion Noir
17 hours agoKamala Harris Panders To Oprah Saying If Someone Breaks Into My House They Getting Shot
17.3K40 -
14:30
IsaacButterfield
1 day ago $0.03 earnedMy Girlfriend Is Trans But I’m Not Gay
14.6K21 -
5:51
Dr. Nick Zyrowski
1 day agoBerberine, Fat Loss & Your Blood Sugar | Must See!
11.7K6 -
10:23
Sideserf Cake Studio
3 hours ago2 Easy Hyperreaslitic Cakes YOU Can Make!
14K3 -
13:46
Tactical Advisor
1 day agoCan a Gun This Small Be Any Good? Smith & Wesson Bodyguard 2.0
13.2K6 -
59:51
Trumpet Daily
1 day agoWhat Is Kamala Harris Trying to Say? - Trumpet Daily | Sept. 20, 2024
17.5K11 -
1:01:22
The Christopher Prosch Show
18 hours agoAre the National Polling Institutions lying to you!??
11.8K5 -
13:34
Ethical Preparedness
18 hours agoThe Cannibals Attack: The Fatal Cost He Paid in His Battle Against Marauders -Post Collapse Medicine
14.1K6