Combination Stacked & Clustered Column Chart in Excel - 2 Examples

In this video I demonstrate how to combine a stacked and clustered column chart. The video takes you through two examples, reflecting the different ways your data may be laid out.

Table of Contents:

00:00 - Example 1
07:41 - Example 2
------------------------

[darthwicked]

Duude! This was amazingly simple and very systematically delivered. Thank you for putting this together it saved me a lot of time!

[catherinepapoutsis]

this video was SO helpful. it's exactly what i was looking for. thank you!

[OIFenrirOI]

Perfect, this was exactly what I needed and you didn't skip over any details like fonts etc. Subscribed!

[TheDangerousKid]

Really helpful video, did exactly what I needed thanks. Just one question when I then tried to add some more data to have a line on it, I couldn’t get it to work. Any ideas how to add that as well? Thanks

[heyheyhey]

Love the super easy-to-understand tutorial!

[beerhistory]

Thanks for this workaround! I did it but with 1 column gap in between the sets, and then I decreased the gap width to fatten the bars and keep two bars of the set together.

[fleathedog]

Exactly what I wanted! I would never have worked this out myself 😵‍💫

[zhengdongzang]

It is sooo helpful because I had been so annoyed by that extra line at the end of the horizontal axis. Now finally got it removed by placeholder!! Thank you!

[digitallearner]

Very helpful tips / hacks and very nicely explained! Thanks!!

[wayneedmondson]

Great chart trickery Chester! Thanks for sharing. Thumbs up!!

[IvanCortinas_ES]

Excellent explanation Chester. Thank you!!!

[prakarshsrivastava]

Thanks...
Your solution worked for me.

[melaniephilip]

This here is the easiest tutorial i found. thank you!!

[romanhnizdiukh]

Thanks for the video, really useful used it to compare data over the year :)

[rohiniyerra]

Very helpful video. Thank you. Can you please show how to add another line with markers to the example 1.

[ruby]

Thankyou so much for this video, it was so helpful!

[Auser]

Do we have the same features in google sheet charts? Pls suggest. Thanks

[invenew]

Thank you for this excellent tutorial...
Could you please explain the benefit of using MAX and adding to the chart but doesn't appear?
Thank once again

[Koby]

This video is great !!!
I have something a little more complex: How can you make p1 and p2 be on 2 different axis? (e.g p1 is in $, and P2 is the number of projects invoved)

[SofiaGonzalez-bvhh]

For some reason I don't get the two columns (P1, P2) just one stacked, I put my info just like you, do you know what may be happening?