Clustered Stacked Bar Chart In Excel 

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!

Really elegant approach, I was reading through another method for doing this that was much more convoluted. Thank you

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!!!!

Nice clear video that explains exactly what I was wanting to learn. Nice job!

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 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!

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!

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!

So grateful to have discovered this channel. Excel all the way.

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.

Thanks for such a clear and simple tutorial for this, saved me at work

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.

SUPER HELPFUL, very clear! Makes my life so much easier! thank you

Thanks Pandi, have been trying to work out how to do this for ages!!

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 !

I really wanna say thank you, you helped me to create the Viz I need to my job presentation.

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.

I have been trying to get this right for ages. Thank you so much for this!

2022 And your video was EXCELLENT for what I needed and there was not another that was as easy to follow! Thank you!

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 the video. It helped me a lot, after many hours of trying to create a graph. Great tutorial.

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.

Been around excel a long time but learned a few new tricks. Well done. Get to 1000 subscribers and monetize! : )

Great video. I find the Chart function to be so counterintuitive, this was very helpful.

Thank you so much for this lesson. It helped me execute exactly what I want.

thank you so much! May God bless you for this valuable lesson.

Very helpful Pandi. Appreciate the walk through. Shaved valuable time off my work. :-)

Data arrangement is the key. Thanks for getting right to it in the video!

thank you very much. I appreciate the data layout being there throughout.

Boy... Precisely what I was looking for, cheers!!

Thank you, this is good information & explained very well in simple way.

Thank you for the clear explanations, exactly what I was trying to accomplish.

It took me forever to do the same thing in Tableau. Thanks man

You are a godsend! I needed this tutorial so bad

Thank you so much.. i was trying create a view with Multiple Values for same Months and this helped a lot

IVE BEEN LOOKING FOR THIS FOR AGES.. Thanks so much!!

Awesome video - exactly what I needed - thank you so much!

Good to realize we can use such table layout to include the Total of the stacked bar

This is exacty what I was looking for! Thank you Pandi! :)

Excellent explanation! It helped me a lot!!! Thanks

Brilliant, smart approach and exactly what I was after - Thank You.

Thank you for this! very easy & quick

Many thanks for these tips. I did not know you could modify the x axis this way with a multiple index.

Thank you so much! You helped me with my planning engineer job! ❤️

Thanks you, this info saved my life.

brilliant🎉 i was thinking about how to do it with combination of cluster and stack. Adding some space is a simple trick

Thank you so much! This is exactly what I needed to present my information!! :)

Thank you very much! this was very easy to follow and made my life much easier! I appreciate this. :)

Very helpful, totally what I needed - Thank you!

Thank you for the explanations. I have a problem with "year axis" my last empty column is creating a new "year" section.

Thank you for this! A simple solution to a complex problem that I was having 😉

Thank you so much, this was very helpful ! You should post more videos 🙂 Subscribed 👍🏻

Brilliant, exactly what I needed. thanks

Really great video, thank you very much! Helped a lot with my work!

saving a lot of headache, thank you so much

Thanks Pandi! Very helpful!

You are the best!!! Thank you million times!

dude this was such a huge help, thankyou

Good Chart Pandi....Keep sharing

Very good tutorial!!! Thank you!!!

doing god's work son, thank you

Thank u your explanation is beautiful

Very clear and useful, thanks!

This was so helpful. Thank you!

Thank you so much, it helps a lot

clear and simple..thank you!

Really helpful, thank you so much!

I am.new to ur channel😊I will follow ur channel closely to learn more excel or if possible, teach us powerpoint skills too😊😊😊

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.

Bigggg thankyou. omg, lol, you have just saved my assignment XD

Absolutely loved it, thanks!

Thank you, this was very useful for my report!

It helped me a lot!! Thanks!

Saved my life! Thnk you!

Awesome ..helped me to get exactly what I want

Thank you very much, this is exactly what I need.

Thank you for the very helpful video :)

i like how he put the total here, nice!

This saved me,.... thank you!!

Excellent. Thank you!

Thank you for sharing!

Dang. This helped out a lot. Thanks!

this video saved me today

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9Nye5NO172A.html

A million thanks!

Thank you so much!!!! I was in a similar predicament with my data.

excellent. clear and easy. thanks

Thank you so much..it is veryyy useful😊👍👍👍

thanks man, helped me out of a jam

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 :)

great tutorial

Hey can I please ask why your excel theme looks so smooth and sleek? Where can I customise that? Thank you!

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 ?

Thanks your videos

Man, this is slick!! Well done

This basically saves my life!

Very nice video . Fair play.

It was helpful. Thanks.

Big THANK YOU!