VERY VALUABLE and right on point - I honestly did not think it was even possible when I began looking for a solution. So thank you thank you thank you!
THANK YOU THANK YOU THANK YOU!! I watched so many tutorials that formatted the data in such ugly ways and I couldn’t understand how to get what I wanted and you nailed it so simply so cleanly and so easy to follow!!
This was the most helpful video! Thank you very much for the detailed tutorial. I searched several forums for information on how to group bars with the stacked chart. I'm happy to see it all lies with the formatting of the data. THANK YOU!!!!
Awesome tutorial, thank you! I had given up trying to make such a chart on my own, but was very easy to follow your instructions and I ended up with a very nice result.
THANK YOU THANK YOU THANK YOU. This is EXACTLY what I am looking for. I have gone thru hours hours of looking on the internet until I found yours. I have subscribed to you channel. The instruction is so easy to understand and follow.
If anyone was having trouble with an extra line at the end of the x axis, I found a solution: put some spaces in the year column two lines below your last line (cell A17 in this case), then make sure that when you select data, your selection includes that row (row 17). I hope this helps some of you!
@@user-tk4ol1ve5o I solved it by typing " '[space] " in that cell corresponding to B16. So the ' mark to tell Excel that there is text in the cell, but then only typing spaces.
Thank you for taking the time to make this video. The only thing I would add is 3 lines showing growth rate for the three regions on a separate axis as a combo chart.
Thank you! This is exactly what I was looking for and your example matches closely to what I need to do. I never would have figured this out on my own.
Thank you for this nice tutorial. I am desperate to find a tutorial which describes how to work around issues such as what to do with the second level horizontal category if there is too much text. How can you amend this second level? I only seem to find ways to amend the first level.
Just wanna say....thank you for the brilliant video tutorial and sharing ur knowledge...its a super great help..exactly what i wanted! Was cracking my head to figure it out. Tremendous help to my presentation 😊😊😊🤩
Is there a way you would be able to omit a Horizontal Label? for example, are you able to omit the Region label but keep each of the 3 columns for each year?
Hey Pandi, Thank you very much. This is very useful. My 2020 x-axis has a grey column boundary after 4 columns unlike 2018, 2019 which have a grey column partition after 5 columns as you have demonstrated. How can I fix it ?
Great video. How do you change the height of the stacks (diff colors) containing the data series values? For example for your first stack NA the value of 1000 - what if you want to increase the height of stack to better fit the data value? Sometimes for very small values excel makes the height of the cell too small to fit the data label font.
I had to put a space in cell B16, otherwise the 2020 doesn't center correctly (i.e. at center of 4 cells instead of 5). Apart from that very useful demo.
Hi. By space do you mean going into cell, hitting the space bar, and exiting the cell? I tried that myself and it didn’t work. The anomaly is driving me crazy.
@@junaidhashim3106 Indeed just like you described. In fact, any text in B16 will fix the alignment of '2020', except that any text other than 'space' will be visible in the chart of course. BTW, I am using Excel 365, not sure if that matters
Hi Thank you. Just wondering whether we could move NA, Euro, Asia labels on the top of the bars (where you got the total)and only keep the year at the bottom?
Thanks for this comment Pete! Monetizing would be a dream. Lately I’ve been considering uploading new videos since a few videos have been getting a decent amount of views.
I was struggling with a stacked-column graph that was being created wrong regardless of transposing the matrix (swapping rows and columns). In the bottom of "more column charts" you can find "stacked-column" again and choose on of multiple options, in my case this included the graph I desired. Perhaps someone else might find value in this.
Looks really nice. Do you see a way to have that working dynamically? E.g. for an unknown number and always growing number of years and changing regions?
Nice tutorial, thank you very much. In case anyone is observing an extra box after ''2020" category, add a dummy label in A17 and extend the range of the "horizontal (category) axis labels" to include this. so the data range under "horizontal (category) axis labels" would be A1:B17. Credits: ua-cam.com/video/9Nye5NO172A/v-deo.html
Could you do another video where you have a data set with two different values? Like one with $ and another with percentages and how to structure them both? Great video
Add column(s) after "Total" for the Percentage(s). Next, right click on the chart and "Change Chart Type" and make it a "Combo" chart. Finally, make the Percentage(s) column a line on the "Secondary Axis"
Nice clear video that explains exactly what I was wanting to learn. Nice job!
VERY VALUABLE and right on point - I honestly did not think it was even possible when I began looking for a solution. So thank you thank you thank you!
I needed to make a stacked clustered bar chart for work today, and you really came through for me. I understand how I need to lay it out now. Thanks!
THANK YOU THANK YOU THANK YOU!! I watched so many tutorials that formatted the data in such ugly ways and I couldn’t understand how to get what I wanted and you nailed it so simply so cleanly and so easy to follow!!
This was the most helpful video! Thank you very much for the detailed tutorial. I searched several forums for information on how to group bars with the stacked chart. I'm happy to see it all lies with the formatting of the data. THANK YOU!!!!
Really elegant approach, I was reading through another method for doing this that was much more convoluted. Thank you
I really wanna say thank you, you helped me to create the Viz I need to my job presentation.
Thanks Pandi, have been trying to work out how to do this for ages!!
So grateful to have discovered this channel. Excel all the way.
This is awesome. Worked right away and solved a big problem for me in a client presentation. Client was very happy with it too. Thanks a bunch!
Thanks for such a clear and simple tutorial for this, saved me at work
Awesome tutorial, thank you! I had given up trying to make such a chart on my own, but was very easy to follow your instructions and I ended up with a very nice result.
THANK YOU THANK YOU THANK YOU. This is EXACTLY what I am looking for. I have gone thru hours hours of looking on the internet until I found yours. I have subscribed to you channel. The instruction is so easy to understand and follow.
Thanks for the video. It helped me a lot, after many hours of trying to create a graph. Great tutorial.
If anyone was having trouble with an extra line at the end of the x axis, I found a solution: put some spaces in the year column two lines below your last line (cell A17 in this case), then make sure that when you select data, your selection includes that row (row 17). I hope this helps some of you!
God bless u my brother
Hi chipmunk! Very desperate for help...I did what you suggested an I'm still stuck with the extra line! Any more explanation?
@@user-tk4ol1ve5o I solved it by typing " '[space] " in that cell corresponding to B16. So the ' mark to tell Excel that there is text in the cell, but then only typing spaces.
You are my life saver! This is super helpful!
And if anyone can't get either of these methods to work, you can add fake data onto the new line and make sure the new bar isn't filled.
Thank you for taking the time to make this video. The only thing I would add is 3 lines showing growth rate for the three regions on a separate axis as a combo chart.
Thank you !! I was searching for the perfect data setting to create a cluster stacked chart, this video is the simple and efficient answer !
Thank you! This is exactly what I was looking for and your example matches closely to what I need to do. I never would have figured this out on my own.
2022 And your video was EXCELLENT for what I needed and there was not another that was as easy to follow! Thank you!
I have been trying to get this right for ages. Thank you so much for this!
Hey can I please ask why your excel theme looks so smooth and sleek? Where can I customise that? Thank you!
Thank you for the explanations. I have a problem with "year axis" my last empty column is creating a new "year" section.
It took me forever to do the same thing in Tableau. Thanks man
Thank you for this nice tutorial. I am desperate to find a tutorial which describes how to work around issues such as what to do with the second level horizontal category if there is too much text. How can you amend this second level? I only seem to find ways to amend the first level.
Just wanna say....thank you for the brilliant video tutorial and sharing ur knowledge...its a super great help..exactly what i wanted! Was cracking my head to figure it out. Tremendous help to my presentation 😊😊😊🤩
Thanks for that, can we create the same graph using pivot table
Thank you so much.. i was trying create a view with Multiple Values for same Months and this helped a lot
Is there a way you would be able to omit a Horizontal Label? for example, are you able to omit the Region label but keep each of the 3 columns for each year?
SUPER HELPFUL, very clear! Makes my life so much easier! thank you
Glad it helped!!! thanks for the comment! :)
i find that there is some wierd extra vertical line in 2020 on the x-axis... putting a space in the last blank row solve the issue for me :)
Please post the solution if you figure this out :)
Hi, can you show how you could erase the vertical line?
great tutorial , How do you add a trendline to every column can that be done?
brilliant🎉 i was thinking about how to do it with combination of cluster and stack. Adding some space is a simple trick
Can I add a line graph to reflect a data point for each column, if yes how?
thx
You are a godsend! I needed this tutorial so bad
Hey Pandi, Thank you very much. This is very useful. My 2020 x-axis has a grey column boundary after 4 columns unlike 2018, 2019 which have a grey column partition after 5 columns as you have demonstrated. How can I fix it ?
thank you so much! May God bless you for this valuable lesson.
@5:02 when i did this, it didnt separate into two layers of axis...why is that?
Can’t seem to get axis label aligned with the columns. Any fixing solution?
Great video. I find the Chart function to be so counterintuitive, this was very helpful.
Great video. How do you change the height of the stacks (diff colors) containing the data series values? For example for your first stack NA the value of 1000 - what if you want to increase the height of stack to better fit the data value? Sometimes for very small values excel makes the height of the cell too small to fit the data label font.
Did you figure it out?
I had to put a space in cell B16, otherwise the 2020 doesn't center correctly (i.e. at center of 4 cells instead of 5). Apart from that very useful demo.
Was struggeling with the same anomaly - would never have thought to put a space there: thanks Xint!
Hi. By space do you mean going into cell, hitting the space bar, and exiting the cell? I tried that myself and it didn’t work. The anomaly is driving me crazy.
@@junaidhashim3106 Indeed just like you described. In fact, any text in B16 will fix the alignment of '2020', except that any text other than 'space' will be visible in the chart of course. BTW, I am using Excel 365, not sure if that matters
Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.
Hi Thank you. Just wondering whether we could move NA, Euro, Asia labels on the top of the bars (where you got the total)and only keep the year at the bottom?
how did you convert your data in this way?
Awesome video - exactly what I needed - thank you so much!
Very helpful Pandi. Appreciate the walk through. Shaved valuable time off my work. :-)
Thank you, this is good information & explained very well in simple way.
Good to realize we can use such table layout to include the Total of the stacked bar
Excellent explanation! It helped me a lot!!! Thanks
Been around excel a long time but learned a few new tricks. Well done. Get to 1000 subscribers and monetize! : )
Thanks for this comment Pete! Monetizing would be a dream. Lately I’ve been considering uploading new videos since a few videos have been getting a decent amount of views.
Thank you so much for this lesson. It helped me execute exactly what I want.
Mr Pandi,is it also possible to create a 3D Column Stacked chart in Excell.I can't find any in the list of charts in Excell.
I was struggling with a stacked-column graph that was being created wrong regardless of transposing the matrix (swapping rows and columns).
In the bottom of "more column charts" you can find "stacked-column" again and choose on of multiple options, in my case this included the graph I desired.
Perhaps someone else might find value in this.
Thanks you, this info saved my life.
IVE BEEN LOOKING FOR THIS FOR AGES.. Thanks so much!!
Looks really nice. Do you see a way to have that working dynamically? E.g. for an unknown number and always growing number of years and changing regions?
This is exacty what I was looking for! Thank you Pandi! :)
Thank u your explanation is beautiful
dude this was such a huge help, thankyou
when i create this, it doesn't break up my different years in different sections. Any idea?
Good Chart Pandi....Keep sharing
Thank you for this! very easy & quick
Boy... Precisely what I was looking for, cheers!!
Thank you for the clear explanations, exactly what I was trying to accomplish.
Many thanks for these tips. I did not know you could modify the x axis this way with a multiple index.
Data arrangement is the key. Thanks for getting right to it in the video!
I am.new to ur channel😊I will follow ur channel closely to learn more excel or if possible, teach us powerpoint skills too😊😊😊
Brilliant, smart approach and exactly what I was after - Thank You.
thank you very much. I appreciate the data layout being there throughout.
saving a lot of headache, thank you so much
Thank you so much! You helped me with my planning engineer job! ❤️
Really great video, thank you very much! Helped a lot with my work!
Thank you so much, this was very helpful ! You should post more videos 🙂 Subscribed 👍🏻
Thank you for this! A simple solution to a complex problem that I was having 😉
Very good tutorial!!! Thank you!!!
Thanks Pandi! Very helpful!
Nice tutorial, thank you very much. In case anyone is observing an extra box after ''2020" category, add a dummy label in A17 and extend the range of the "horizontal (category) axis labels" to include this. so the data range under "horizontal (category) axis labels" would be A1:B17. Credits: ua-cam.com/video/9Nye5NO172A/v-deo.html
this video saved me today
Thanks bro. You are a big help!
You are the best!!! Thank you million times!
Very helpful, totally what I needed - Thank you!
Bigggg thankyou. omg, lol, you have just saved my assignment XD
It helped me a lot!! Thanks!
This was so helpful. Thank you!
Very clear and useful, thanks!
doing god's work son, thank you
Really helpful, thank you so much!
Absolutely loved it, thanks!
Brilliant, exactly what I needed. thanks
Thanks for watching! Glad it helped! :)
Thank you so much, it helps a lot
i like how he put the total here, nice!
Could you do another video where you have a data set with two different values? Like one with $ and another with percentages and how to structure them both? Great video
Add column(s) after "Total" for the Percentage(s). Next, right click on the chart and "Change Chart Type" and make it a "Combo" chart. Finally, make the Percentage(s) column a line on the "Secondary Axis"
Saved my life! Thnk you!
Thank you so much..it is veryyy useful😊👍👍👍
Awesome ..helped me to get exactly what I want
Thank you so much! This is exactly what I needed to present my information!! :)
This saved me,.... thank you!!
Thank you for the very helpful video :)
Man, this is slick!! Well done
Great video, thank you!