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
------------------------
Пікірлер: 32
Love the super easy-to-understand tutorial!
this video was SO helpful. it's exactly what i was looking for. thank you!
Excellent explanation Chester. Thank you!!!
Great chart trickery Chester! Thanks for sharing. Thumbs up!!
Brilliant! Thank you so much!
This here is the easiest tutorial i found. thank you!!
Excellent, thank you!
Perfect, this was exactly what I needed and you didn't skip over any details like fonts etc. Subscribed!
@ChesterTugwell
Жыл бұрын
Thanks for the sub!
Brilliant. You made my day
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.
Thanks... Your solution worked for me.
Exactly what I wanted! I would never have worked this out myself 😵💫
very helpful.
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!
Thanks for the video, really useful used it to compare data over the year :)
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
Thankyou so much for this video, it was so helpful!
Very helpful video. Thank you. Can you please show how to add another line with markers to the example 1.
Thank you!!
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?
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)
very clever 😀 very smart
If only you had one that did breakdown over months and years! It's the years bit that is currently catching me out...
Do we have the same features in google sheet charts? Pls suggest. Thanks
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.....
How do I get the chart to update if I update the data?
OK, I think I need to inside edit my "little gray cells".... Cheers
How about bar chart (horizontal bars)?
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
5 ай бұрын
Hi, did you find a solution for this? I am in the same situation.