019. How to create a Clustered Stacked Column Chart in Excel

[@manuelamel18]

Super useful and clear :)

[@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

[@worapannamakul1077]

thank you so much

[@EXCELWIZARDINMINUTES]

You are welcome! :)

[@nahlas.3836]

Wow😮❤

[@EXCELWIZARDINMINUTES]

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

[@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

[@CelPeterineOrias]

Is it possible to apply this chart type in GSheet?

[@EXCELWIZARDINMINUTES]

@CelPeterineOrias i know u can do stacked charts in google sheets but i never tried a clustered column chart. I personally dont like to use google sheets 😅

[@CelPeterineOrias]

@@EXCELWIZARDINMINUTES, thanks so much for noticing and replying to my comment. 🙂 I personally prefer Excel as well, but work-related stuffs must be in Sheet. 😅 I'm just hopeful that Sheet will be a little more advance, someday. 🤞Anyway, have a good day!

[@EXCELWIZARDINMINUTES]

@CelPeterineOrias try my strategy on google sheets. If it doesnt work, u can always upload a normal excel workbook that takes google sheet data and creates the chart. There are also tools that can transfer data automatically

[@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