Clustered Stacked Bar Chart In Excel

If you liked this video and want to see more content added to this channel, contribute to my Patreon account: www.patreon.com/user/overview...
Add me on Linkedin: / pandimengri
In this video you will learn how to plot sales data by region broken down by quarter.

[@reneaflowers5490]

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

[@andrewyang3628]

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!

[@j.l.marcher7423]

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.

[@justinmwitt]

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

[@curtishauser6105]

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!

[@user-sn1jx4nd7o]

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

[@anne-claired.7207]

Thank you !! I was searching for the perfect data setting to create a cluster stacked chart, this video is the simple and efficient answer !

[@ricardofernandesdesouza9823]

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

[@richardnyakundi5895]

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

[@BittyBug]

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!

[@houriibunga3269]

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 😊😊😊🤩

[@jenniferthorland7970]

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

[@marilynzube605]

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.

[@milkywayouterspace]

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.

[@mmariappa]

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

[@jeffblackman6960]

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

[@johnbielick2700]

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

[@dafneulate5998]

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

[@PandiMengri]

Glad it helped!!! thanks for the comment! :)

[@zelb.1691]

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

[@suzettetorres7417]

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

[@tripreed]

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

[@amandal8404]

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

[@ashwinimuralidharan9957]

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

[@glgstdt]

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

[@rinatohad]

Thanks for the video. It helped me a lot, after many hours of trying to create a graph. Great tutorial.

[@ivanisahi2832]

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

[@hectormiguelvinuezabarroso3967]

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

[@pikapao93]

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

[@stuartwickson8535]

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

[@moohart]

Very helpful, totally what I needed - Thank you!

[@mailtoprabhath]

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

[@sarmehdi]

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

[@enhypedbyjw]

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

[@EmoDontMix]

You are a godsend! I needed this tutorial so bad

[@C05Mik]

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

[@WalidAldeeb]

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.

[@hosnearaakter3801]

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

[@Angerblaze]

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

[@lovemetalb]

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

[@cazero8]

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

[@hewiel]

Thanks you, this info saved my life.

[@SS-yu6xt]

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

[@srinivasbhagavatula7563]

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

[@zsoltkiss8256]

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

[@emilyhughes4297]

Thank you, this was very useful for my report!

[@mianish01]

Brilliant, exactly what I needed. thanks

[@PandiMengri]

Thanks for watching! Glad it helped! :)

[@berky1976]

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

[@sharadraut1206]

Thank you for this! very easy & quick

[@CarshaltonAdvisory]

Thanks Pandi! Very helpful!

[@zohrehbasiri7988]

Absolutely loved it, thanks!

[@harrymarcus2017]

This was so helpful. Thank you!

[@rajeshwariv3760]

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

[@lengdv]

clear and simple..thank you!

[@knh6303]

Very clear and useful, thanks!

[@marcusberankis8960]

dude this was such a huge help, thankyou

[@marcelosaravia4567]

Saved my life! Thnk you!

[@caycoo]

Man, this is slick!! Well done

[@ananyasaroha1233]

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

[@LetsPlayGoodGamesTogether]

Very good tutorial!!! Thank you!!!

[@Juriarte23]

Dang. This helped out a lot. Thanks!

[@sureshmchettiar9480]

Thank u your explanation is beautiful

[@ericzheng4815]

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

[@maame2981]

Really helpful, thank you so much!

[@skylarlee8070]

It helped me a lot!! Thanks!

[@urituval]

excellent. clear and easy. thanks

[@ZombieFighterX]

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!

[@glennchiajunweng8547]

God bless u my brother

[@user-tk4ol1ve5o]

Hi chipmunk! Very desperate for help...I did what you suggested an I'm still stuck with the extra line! Any more explanation?

[@j.l.marcher7423]

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

[@yiqingyao8732]

You are my life saver! This is super helpful!

[@GwynH-wf4ds]

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.

[@Indestructibly97]

This is awesome, man, thanks a lot!

[@exonzigma]

saving a lot of headache, thank you so much

[@PKMNsandy]

Thank you for the very helpful video :)

[@alexeykoltsov8208]

very helpful, thanks!

[@priyagerard2590]

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

[@avinashsoni8034]

It was helpful. Thanks.

[@silkysoy1794]

Excellent. Thank you!

[@kamnakaura]

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

[@yum-asmr526]

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

[@peacemakersmat5]

doing god's work son, thank you

[@chenbart132]

This basically saves my life!

[@supriyaprasad4994]

Awesome ..helped me to get exactly what I want

[@Dexterous100]

Thank you for sharing!

[@ShanaliGovender]

A million thanks!

[@kwanpakshing]

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

[@OMAaztek]

Nice , what i needed!

[@icesummer1725]

i like how he put the total here, nice!

[@surabhichaturvedi4090]

Thank you so much,. This really helped :)

[@davidlattimer18]

Brilliant, thank you so much.

[@violetgrowers]

thanks man, helped me out of a jam

[@nadenejohnson2122]

Super helpful thank you

[@VoMinhHai1914]

Thanks your videos

[@zhenggao4963]

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

[@charleskevinmarco4419]

this video saved me today

[@spencerthomas811]

Very nice video . Fair play.

[@cutestbear3327]

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

[@arealpackerfan1876]

Awesome, thank you!

[@ejidikechibuisipromise9618]

great tutorial

[@gamer4556]

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

[@PandiMengri]

Thanks for the feedback!

[@tiffany9720]

Big THANK YOU!

[@xlnt]

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.

[@RussellDionGreen]

Was struggeling with the same anomaly - would never have thought to put a space there: thanks Xint!

[@junaidhashim3106]

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.

[@xlnt]

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

[@giorgosi.fovakis8810]

Excellent you are great!

[@paulljucovic6518]

That was amazing!

[@ryglseba]

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