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

[@manuelamel18]

Super useful and clear :)

[@nahlas.3836]

Wow😮❤

[@EXCELWIZARDINMINUTES]

Thanks Nahlas! Who knew u could do this in excel ? Hehe

[@worapannamakul1077]

thank you so much

[@EXCELWIZARDINMINUTES]

You are welcome! :)

[@xwalkerm]

Great tips, thanks

[@EXCELWIZARDINMINUTES]

Thanks Mark!:)

[@MoonShine-bs6cl]

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

[@shubhamchavan2441]

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

[@bernardbaz2003]

Hi, very clever. By the way, from your accent, I guess you're Lebanese, aren't you ?

[@EXCELWIZARDINMINUTES]

Spot on! :)

[@MoonShine-bs6cl]

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]

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]

​@@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]

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)

[@mohammadalawneh5041]

hello, do you have instagram ? i want to ask you smth

[@EXCELWIZARDINMINUTES]

Rami_ajaoude