Excel Visualization | How To Combine Clustered and Stacked Bar Charts

In this Excel tutorial, I will show you how to create a graph with clustered bar and stacked bar graphs into a single chart.
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
📘 Facebook Page → / madeinpython
📘 More tutorial videos on my website → LearnDataAnalysis.org
✉️ Business Inquiring: [e-mail]
#Excel #ExcelChart #ExcelVisualization #Visualization

[@harishsivaramakrishnan7096]

you're a life saver man!

[@MustafaAli-ri3bx]

I literally spend an hour finding a solution for this. Thanks man!

[@jiejenn]

Glad the video helped.

[@jiyasplaytimeshowtell8525]

Thank you very much, exactly what I needed 👍

[@johncooper3295]

Great Job! super helpful!

[@tomtom8995]

Thanks for this Jie - very useful

[@salmikhan]

Thanks man. You saved my entire day worth of effort. 🤝

[@ahmadmassoudamiry7008]

Thank you the video was really helpful ❤

[@MarleneGeary]

This was awesome. Thank you.

[@javierlucia8061]

Thanks, I couldn't align without this structure.

[@JamesHu007]

Thank you. Great video, exactly what I needed. Quick question - what is the purpose of adding the “spacer” column?

[@windy26011]

Thank you very much this is what I need

[@holyshapes]

You saved my life. Thank you!

[@kellymcalister517]

Fantastic. Thank you!🥰

[@3403flagan]

great video!

[@phl.p2459]

you save my life!!!! thank you :)

[@yanjingli1124]

Gonna cry after I see exactly what I am looking for!!!

[@jiejenn]

Glad the video helped.

[@jbasilio2205]

Me right now huhu

[@sallyho146]

@@jiejennThanks. If I need to put the primary users and secondary users in column B and C, how do stack primary and secondary users and make it side by side with stack repeat and new users? Two clustered bars with two stack information?

[@brendagatewood1051]

Thank you!! Just what I needed!!

[@jiejenn]

Glad the video helped!

[@delin3001]

thank you very much

[@SuperNirmal1981]

So helpful.. thank you so much.. you made my day 🎉👍

[@jiejenn]

Glad the video helped.

[@SuperNirmal1981]

@@jiejenn very much in deed... I received an appreciation for this as well since others dint know how to go about... All credit to you.. there were similar videos but yours helped and answered exactly what I wanted.. thanks for your videos 🙏

[@morjes152]

god-tier content. Kittos avusta!!!

[@VEMULAWADASANGEETHAM]

if the data is in 4 columns & I need first two as Column chart, other two into stacked. Thus overvall 3 bars, where the last one is stacked of 3 & 4 column data . for this type, how many spacer columns needed ?

[@MayankPurohit8]

Any way to hide spacer column from data table, as I've to show data table below chart.

[@shuixianyuan]

how can I move the stacked bar charts to the left of the clustered bar chart instead of to the right?

[@cogiangxcel693]

thank you very much very creative to make the space column then make it invisible

[@jiejenn]

👍👍👍

[@vimalkaura6833]

One problem I am facing is that the browser is coming up for bar type selection instead of user in combo chart option...so I can't go further.

[@victorolatope5148]

Pls what did you press to align the stacked bar

[@jiejenn]

Can you be more specific?

[@victorolatope5148]

@@jiejenn thanks Jenn. on the stacked bars - when you changed the gap of the bottom series and the top looked like it was hanging. Then you pressed the keyboard to align them - that’s what I’m referring to.

[@jiejenn]

You set the gap value then tab out.

[@anthonettec.2203]

Is there a way to hide the spacer column? I have to add a data table in the graph.

[@jiejenn]

Unfortunately I haven't able to find a work around.

[@billsk8]

Is this possible with horizontal bars by any chance ?

[@jiejenn]

You should be able to since you are basically rotating the axis.

[@billsk8]

@@jiejennDidn't think you could do that !

[@danmertz92]

But what if you only have 1 stacked bar in your chart, not multiple bars, or 7 bars as your example? When I add the line, it shifts the bar over to the far left of the chart and has a line going across part of the stacked bar and extending to the blank space on the right half of the graph. It will not center the bar.

[@jiejenn]

This is something I am unable to help without look at how you set up your table unfortunately.

[@Glizzardacus]

@@jiejenn I think what they are asking is - what if you have more than 3 columns, like your example.
For instance, if there are 5 columns, 4 of which should be stacked, and only 1 to be left as a cluster, how many spacer columns (or rows) would you add?

[@nitheshshetty1714]

Then how to remove spacer

[@harishsivaramakrishnan7096]

this lia gharani is totally basic compared to you. she probably should teach excel to children.