Excel Visualization | How To Combine Clustered and Stacked Bar Charts

[@MustafaAli-ri3bx]

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

[@jiejenn]

Glad the video helped.

[@tomtom8995]

Thanks for this Jie - very useful

[@raja.mubbasshir9072]

Thank you I just used the trick of overlapping it workd

[@morjes152]

god-tier content. Kittos avusta!!!

[@sharonmusee673]

Lifesaving! Thank you so much!

[@salmikhan]

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

[@worldofdata]

thanks for your help, really saved me :)

[@harishsivaramakrishnan7096]

you're a life saver man!

[@mostafaelsharef9551]

Very effective, thank you❤

[@brendagatewood1051]

Thank you!! Just what I needed!!

[@jiejenn]

Glad the video helped!

[@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?

[@arifulislam7634]

This is amazing. Thanks!

[@holyshapes]

You saved my life. Thank you!

[@MayankPurohit8]

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

[@MarleneGeary]

This was awesome. Thank you.

[@windy26011]

Thank you very much this is what I need

[@johncooper3295]

Great Job! super helpful!

[@phl.p2459]

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

[@jiyasplaytimeshowtell8525]

Thank you very much, exactly what I needed 👍

[@3403flagan]

great video!

[@kellymcalister517]

Fantastic. Thank you!🥰

[@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 ?

[@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 🙏

[@ahmadmassoudamiry7008]

Thank you the video was really helpful ❤

[@JamesHu007]

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

[@cogiangxcel693]

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

[@jiejenn]

👍👍👍

[@javierlucia8061]

Thanks, I couldn't align without this structure.

[@shuixianyuan]

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

[@fidaarackal6282]

Can I make this in 3D columns ?

[@sliiiin]

great! Thank you!

[@corinnevickers9004]

Thank you!!!!

[@delin3001]

thank you very much

[@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.

[@anthonette.c]

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.

[@JulienB_BTW]

Is this possible with horizontal bars by any chance ?

[@jiejenn]

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

[@JulienB_BTW]

@@jiejennDidn't think you could do that !

[@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.

[@nitheshshetty1714]

Then how to remove spacer

[@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?

[@harishsivaramakrishnan7096]

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

[@jomarimercado9884]

thank you so much, exactly what I needed!