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
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 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)
Very useful! Also very easy to understand
@tanakornpromthep9025 always nice to hear such nice words 😀
Great tips, thanks
Thanks Mark!:)
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
Super useful and clear :)
thank you so much
You are welcome! :)
Is it possible to apply this chart type in GSheet?
@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
How can change Y axis value like 1,2,3
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 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)
Wow😮❤
Thanks Nahlas! Who knew u could do this in excel ? Hehe
Hi, very clever. By the way, from your accent, I guess you're Lebanese, aren't you ?
Spot on! :)
hello, do you have instagram ? i want to ask you smth
Rami_ajaoude