Combination Stacked & Clustered Column Chart in Excel - 2 Examples

Поділитися
Вставка
  • Опубліковано 15 гру 2024

КОМЕНТАРІ • 37

  • @ChesterTugwell
    @ChesterTugwell  3 місяці тому

    An alternative way to create column chart with Edraw Software: bit.ly/46Q4TTn

  • @darth2wicked
    @darth2wicked 2 місяці тому

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

  • @beerhistory
    @beerhistory Рік тому +1

    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.

  • @catherinepapoutsis2860
    @catherinepapoutsis2860 2 роки тому +4

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

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

  • @OIFenrirOI
    @OIFenrirOI Рік тому +1

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

  • @fleathedog
    @fleathedog 9 місяців тому

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

  • @heyheyhey4040
    @heyheyhey4040 2 роки тому +2

    Love the super easy-to-understand tutorial!

  • @melaniephilip9835
    @melaniephilip9835 2 роки тому

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

  • @prakarshsrivastava200
    @prakarshsrivastava200 2 роки тому

    Thanks...
    Your solution worked for me.

  • @rohiniyerra9265
    @rohiniyerra9265 Рік тому

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

  • @digitallearner7948
    @digitallearner7948 3 місяці тому

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

  • @alcapone99231
    @alcapone99231 2 роки тому

    Brilliant. You made my day

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

  • @IvanCortinas_ES
    @IvanCortinas_ES 3 роки тому

    Excellent explanation Chester. Thank you!!!

  • @wayneedmondson1065
    @wayneedmondson1065 3 роки тому

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

  • @Auser0205
    @Auser0205 Рік тому

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

  • @invenew
    @invenew 2 роки тому

    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

  • @JWB1081
    @JWB1081 2 роки тому

    Excellent, thank you!

  • @roastinred
    @roastinred Рік тому

    How about bar chart (horizontal bars)?

  • @SofiaGonzalez-bv1hh
    @SofiaGonzalez-bv1hh 2 роки тому

    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?

  • @ruby007
    @ruby007 6 місяців тому

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

  • @romanhnizdiukh4191
    @romanhnizdiukh4191 7 місяців тому

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

  • @jemimasam2590
    @jemimasam2590 2 роки тому

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

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

  • @Koby2565
    @Koby2565 6 місяців тому

    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)

  • @oussamaadd9196
    @oussamaadd9196 2 роки тому

    very helpful.

  • @jenbenfenhen
    @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
      @lucywilson4358 10 місяців тому

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

  • @salvadorepozzi8646
    @salvadorepozzi8646 3 роки тому

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

  • @chrismunshaw4855
    @chrismunshaw4855 25 днів тому

    Thank you!

  • @ErrorInPerfection
    @ErrorInPerfection 10 місяців тому

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

  • @TsheringYangki-yi7cs
    @TsheringYangki-yi7cs 8 місяців тому

    Thank you!!

  • @tiquiwanes2078
    @tiquiwanes2078 2 роки тому

    Brilliant! Thank you so much!