019. How to create a Clustered Stacked Column Chart in Excel
In this lesson, you will learn a professional trick on How to create a Clustered Stacked Column Chart in Excel. If you try to have both of them together, you will quickly see that you can't. Either you have a column chart or you have a clustered chart. Well, watch this short video and add it to your skillset as this situation comes frequently in real life situations
Content: stacked and clustered combination graph in excel, difference between stacked and clustered chart, primary and secondary axis same scale, how to create a stacked bar chart in excel, excel chart tricks, clustered stacked bar chart in excel, how to create a clustered stacked bar chart in excel, best practices for charts in excel, advanced bar chart tips and tricks in excel, tips and tricks for bar charts in excel, tips and tricks for bar charts, excel bar chart hack
Link to file: mega.nz/file/TCw2WKRJ#Mz7K0Ag...
#Excel #MsExcel #Chart
Пікірлер: 18
Super useful and clear :)
Wow😮❤
@EXCELWIZARDINMINUTES
2 ай бұрын
Thanks Nahlas! Who knew u could do this in excel ? Hehe
Great tips, thanks
@EXCELWIZARDINMINUTES
Жыл бұрын
Thanks Mark!:)
@MoonShine-bs6cl
3 ай бұрын
You have only 1 row category per group what if I have 2 or 3 rows category per group... Pls help me to prepare this chart... It wil be helpful at the earliest
thank you so much
@EXCELWIZARDINMINUTES
Жыл бұрын
You are welcome! :)
How can change Y axis value like 1,2,3
@EXCELWIZARDINMINUTES
Ай бұрын
Am not sure i understood what you mean. You can set the values of the y axis from the chart options. Feel free to look at the basic videos in my chart playlist
Hi, very clever. By the way, from your accent, I guess you're Lebanese, aren't you ?
@EXCELWIZARDINMINUTES
3 ай бұрын
Spot on! :)
Hi i tried this but for me I'm not getting it why... Please can you help me with mail id that i can share dummy data and please you can help me... Thanks in advance
@EXCELWIZARDINMINUTES
3 ай бұрын
I suggest you download the file: mega.nz/file/TCw2WKRJ#Mz7K0AgU0i6enV1Ozvr5vCc-MLGOT6vupVuAo4RfnaY Try to follow the instructions step by step and i m sure u will ace it! :)
@MoonShine-bs6cl
3 ай бұрын
@@EXCELWIZARDINMINUTES This Yes i am getting it when I have only 1 row of category data as you have in your data, but my requirement is I am having for Examples: Group 1 -- Major cat 1 & Major Cat 2 & Major cat 3 Group 2 - Major cat 1 & Major Cat 2 & Major Cat 3 Group 3 - Major cat 1 & Major Cat 2 & Major Cat 3 As I have 3 rows after each group it's not giving this output, but when I have only 1 row like your dataset I am getting this result. Please help me how to do if I have 3 or more rows for each group. Thanks in advance
@EXCELWIZARDINMINUTES
3 ай бұрын
U only have 2 axis to do the work. In ur case, u might try to make several charts and make them one on top of the other one (removing border colot and chart area color)
hello, do you have instagram ? i want to ask you smth
@EXCELWIZARDINMINUTES
Жыл бұрын
Rami_ajaoude