Combination Stacked & Clustered Column Chart in Excel - 2 Examples

Combination Stacked & Clustered Column Chart in Excel - 2 Examples

Chester Tugwell

2 года назад

110,232 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

beerhistory
beerhistory - 21.09.2023 01:37

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.

Ответить
jenbenfenhen
jenbenfenhen - 08.09.2023 07:16

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.

Ответить
x
x - 30.08.2023 16:32

How about bar chart (horizontal bars)?

Ответить
rohini yerra
rohini yerra - 22.06.2023 05:26

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

Ответить
OIFenrirOI
OIFenrirOI - 17.03.2023 15:28

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

Ответить
EmmaRandomAs
EmmaRandomAs - 15.03.2023 01:48

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

Ответить
Zhengdong Zang
Zhengdong Zang - 15.02.2023 21:49

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!

Ответить
Joey Wong
Joey Wong - 02.02.2023 06:15

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

Ответить
Catherine Papoutsis
Catherine Papoutsis - 14.11.2022 21:18

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

Ответить
Jemima Sam
Jemima Sam - 07.11.2022 16:40

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

Ответить
tiquiwan es
tiquiwan es - 26.09.2022 16:40

Brilliant! Thank you so much!

Ответить
Melanie Philip
Melanie Philip - 08.08.2022 12:41

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

Ответить
AIRTV
AIRTV - 23.06.2022 14:55

Brilliant. You made my day

Ответить
JWB1081
JWB1081 - 15.06.2022 22:42

Excellent, thank you!

Ответить
Sofia Gonzalez
Sofia Gonzalez - 02.06.2022 19:52

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?

Ответить
invenew 2018
invenew 2018 - 30.05.2022 02:40

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

Ответить
prakarsh srivastava
prakarsh srivastava - 17.05.2022 13:02

Thanks...
Your solution worked for me.

Ответить
heyheyhey
heyheyhey - 07.04.2022 13:28

Love the super easy-to-understand tutorial!

Ответить
oussama add
oussama add - 13.03.2022 14:09

very helpful.

Ответить
Wayne Edmondson
Wayne Edmondson - 22.12.2021 09:24

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

Ответить
Salvadore Pozzi
Salvadore Pozzi - 20.12.2021 20:18

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

Ответить
Iván Cortinas
Iván Cortinas - 20.12.2021 19:54

Excellent explanation Chester. Thank you!!!

Ответить