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!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#Excel #ExcelChart #ExcelVisualization #Visualization

[MustafaAli-ribx]

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

[jiyasplaytimeshowtell]

Thank you very much, exactly what I needed 👍

[jomarimercado]

thank you so much, exactly what I needed!

[salmikhan]

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

[ahmadmassoudamiry]

Thank you the video was really helpful ❤

[javierlucia]

Thanks, I couldn't align without this structure.

[JamesHu]

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

[windy]

Thank you very much this is what I need

[SuperNirmal]

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

[yanjingli]

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

[cogiangxcel]

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

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

[MayankPurohit]

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?

[vimalkaura]

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.

[victorolatope]

Pls what did you press to align the stacked bar

[anthonettec.]

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

[billsk]

Is this possible with horizontal bars by any chance ?

[danmertz]

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.

[harishsivaramakrishnan]

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