Premium Only Content

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
-
2:51:11
TimcastIRL
3 hours agoUNHINGED Liberals PROTEST Colbert Cancellation In NYC, Propaganda Machine IS COOKED | Timcast IRL
139K50 -
2:42:48
The Quartering
3 hours agoToday's News Chat & Act 2 Of Expedition 33
25.6K2 -
LIVE
SpartakusLIVE
4 hours agoMonday MOTIVATION || Games w/ the BOYS into the NIGHT
466 watching -
3:16:02
Barry Cunningham
4 hours agoNEWS ON THE PLOT AGAINST THE PRESIDENT AND IT'S A MOVIE NIGHT!
53.3K35 -
2:00:32
Glenn Greenwald
6 hours agoWorld Finally Horrified by Israel's Atrocities in Gaza; Mass Starvation Expert Warns of Spiraling Crisis in Gaza; AOC Votes to Fund Israel's Iron Dome | SYSTEM UPDATE #489
58.6K96 -
LIVE
Spartan
3 hours agoSpartan - Pro Halo Player for OMiT | Scrims vs OMiT Black
39 watching -
LIVE
crgoodw1n
2 hours agoMonday stream Pt.2! Max Traders are almost here!
136 watching -
DVR
Gurk
1 hour ago $0.25 earnedMLB CO OP
7.29K -
1:46:27
Tim Pool
10 hours agoSin Frontera: The End of Illegal Immigration (DOCUMENTARY PREMIERE - 6pm EST)
185K58 -
LIVE
VapinGamers
2 hours ago $0.93 earnedDestiny 2 - Edge of Fate Legendary Run and AD Testing RTMP Pass Thru - !rumbot !music
127 watching