Combination Stacked & Clustered Column Chart in Excel - 2 Examples

Download the featured file here: www.bluepecantraining.com/wp-...
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
------------------------

[@heyheyhey4040]

Love the super easy-to-understand tutorial!

[@catherinepapoutsis2860]

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

[@IvanCortinas_ES]

Excellent explanation Chester. Thank you!!!

[@wayneedmondson1065]

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

[@fleathedog]

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

[@tiquiwanes2078]

Brilliant! Thank you so much!

[@OIFenrirOI]

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

[@ChesterTugwell]

Thanks for the sub!

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

[@JWB1081]

Excellent, thank you!

[@alcapone99231]

Brilliant. You made my day

[@prakarshsrivastava200]

Thanks...
Your solution worked for me.

[@ruby007]

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

[@melaniephilip9835]

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

[@romanhnizdiukh4191]

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

[@zhengdongzang3557]

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!

[@ChesterTugwell]

You're welcome!

[@oussamaadd9196]

very helpful.

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

[@rohiniyerra9265]

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

[@Koby2565]

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)

[@TsheringYangki-yi7cs]

Thank you!!

[@EmmaRandomAs]

If only you had one that did breakdown over months and years! It's the years bit that is currently catching me out...

[@rohitchaddha9]

very clever 😀 very smart

[@Auser0205]

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

[@SofiaGonzalez-bv1hh]

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?

[@joeywong4358]

How can I add a single line to the chart? I want to show the data similar to the combo chart yet it does not have stacked columns.....

[@roastinred]

How about bar chart (horizontal bars)?

[@salvadorepozzi8646]

OK, I think I need to inside edit my "little gray cells".... Cheers

[@jemimasam2590]

How do I get the chart to update if I update the data?

[@jenbenfenhen]

Unfortunately the "select data' section of your video doesn't work on Mac the same way. I'm stuck on how to add the labels on the axis because a window doesn't pop up allowing me to choose what I want to edit.

[@lucywilson4358]

Hi, did you find a solution for this? I am in the same situation.