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

  • @heyheyhey4040
    @heyheyhey40402 жыл бұрын

    Love the super easy-to-understand tutorial!

  • @catherinepapoutsis2860
    @catherinepapoutsis2860 Жыл бұрын

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

  • @IvanCortinas_ES
    @IvanCortinas_ES2 жыл бұрын

    Excellent explanation Chester. Thank you!!!

  • @wayneedmondson1065
    @wayneedmondson10652 жыл бұрын

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

  • @tiquiwanes2078
    @tiquiwanes2078 Жыл бұрын

    Brilliant! Thank you so much!

  • @melaniephilip9835
    @melaniephilip98352 жыл бұрын

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

  • @JWB1081
    @JWB10812 жыл бұрын

    Excellent, thank you!

  • @OIFenrirOI
    @OIFenrirOI Жыл бұрын

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

  • @ChesterTugwell

    @ChesterTugwell

    Жыл бұрын

    Thanks for the sub!

  • @alcapone99231
    @alcapone992312 жыл бұрын

    Brilliant. You made my day

  • @beerhistory
    @beerhistory10 ай бұрын

    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.

  • @prakarshsrivastava200
    @prakarshsrivastava2002 жыл бұрын

    Thanks... Your solution worked for me.

  • @fleathedog
    @fleathedog5 ай бұрын

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

  • @oussamaadd9196
    @oussamaadd91962 жыл бұрын

    very helpful.

  • @zhengdongzang3557
    @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

    @ChesterTugwell

    Жыл бұрын

    You're welcome!

  • @romanhnizdiukh4191
    @romanhnizdiukh41913 ай бұрын

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

  • @invenew
    @invenew2 жыл бұрын

    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

  • @ruby007
    @ruby007Ай бұрын

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

  • @rohiniyerra9265
    @rohiniyerra9265 Жыл бұрын

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

  • @TsheringYangki-yi7cs
    @TsheringYangki-yi7cs3 ай бұрын

    Thank you!!

  • @SofiaGonzalez-bv1hh
    @SofiaGonzalez-bv1hh2 жыл бұрын

    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?

  • @Koby2565
    @Koby25652 ай бұрын

    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)

  • @ErrorInPerfection
    @ErrorInPerfection6 ай бұрын

    very clever 😀 very smart

  • @EmmaRandomAs
    @EmmaRandomAs Жыл бұрын

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

  • @Auser0205
    @Auser02059 ай бұрын

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

  • @joeywong4358
    @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.....

  • @jemimasam2590
    @jemimasam2590 Жыл бұрын

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

  • @salvadorepozzi8646
    @salvadorepozzi86462 жыл бұрын

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

  • @roastinred
    @roastinred11 ай бұрын

    How about bar chart (horizontal bars)?

  • @jenbenfenhen
    @jenbenfenhen10 ай бұрын

    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

    @lucywilson4358

    5 ай бұрын

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

Келесі