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
@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 😅
@@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!
@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
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
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! :)
@@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
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)
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