Premium Only Content

Excel: Extract unique items for dynamic data validation drop down list
Jan 3, 2018 Excel Dashboards & Reports
Easy steps to create a clustered stacked column chart in Excel - this chart is both stacked and clustered. This type of chart is not available in the standard Excel chart selection. With a few steps, you'll learn how to create this from scratch.
One way of creating a clustered and stacked column chart combination is to use both the primary and secondary Y-axis. One problem you'll run into is that they will likely have a different minimum and maximum which will show the wrong visualization. You need to ensure that both the primary and secondary y-axis have the same minimum and maximum in a dynamic way (without manually fixing these values). I show you the trick on how you can set this up.
🡻 Download the workbook here
http://www.xelplus.com/excel-clustered-column-and-stacked-chart/
Links to related videos:
Charts Basics: https://youtu.be/DAU0qqh_I-A
Dynamic Charts based on drop-down selection: https://youtu.be/22jcw5slQJk
★ 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
-
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
52 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
212 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
318 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
66.8K29 -
37:08
Standpoint with Gabe Groisman
23 hours agoDOGE The UK?! With Liz Truss
26.5K12 -
56:39
SLS - Street League Skateboarding
6 days agoHIGHEST SCORING KNOCKOUT ROUND OF ALL TIME! Felipe Gustavo, Dashawn Jordan, Filipe Mota & more...
21.7K1 -
14:26
Breaking Points
1 day agoWOKE VS BASED?: Saagar And Ryan Play A Game
24.2K6 -
5:29:58
SoundBoardLord
8 hours agoThe Red Dead Journey Continues!!!
23.1K1