You continue to amaze me. I've made charts like this before, but not with the white separator between groups. Most of my users are amazed enough with separating the groups. EXCELent!
Fantastic - thank you!! Clunky that we should have to "trick" Excel like this. You would think that they would have got their heads around this by now. But, no, awesome - thank you for thinking outside the square when I no longer have time to!!
Thank you so much for your video. I was stuck trying to create a graph exactly like the one you are showing. You helped me SO much, you really made my day. Thanks!!!!
Hi Steven, not sure if you can do this when starting from Word. That has limited options. I would recommend making your chart in Excel and then copy/pasting special your chart into your Word file. I will have to do a post to show you how in the near future. Thanks for the question.
I knew it, I knew it... I KNEW IT!! I knew this type of presentation must have been out there, but after viewing multiple vids this is the only one I found that demo's it!!! Kudos! One additional tip: In 2013 you can select individual sections of the bar graphs and make them custom colors. Thus in this example you could change the entire Budgeted column into hues of green, and the entire Actual column into hues of red. It's a bit of effort but can be quite visually distinctive!
iammarzhie You are welcome. Glad to help iammarzhie. But I am a consultant, so maybe I should take the post down :) lol Thanks for the nice comment. Steve=True
exceldashboards This works almost perfect. Just one more minor concern is that how to secure the category label at the center. I have tried to format the source data but it's not working (multi-level category level box is already ticked). Maybe you could help me. Thanks in advance!
iammarzhie Hi iammarzhie, not sure your exact problem. If you want the center to show the tick mark, enter a space in the spreadsheet cell that would normally hold a category. Hope this helps. Steve=True
Nick, thanks for the nice comment and I am so glad it was easy. Hopefully you signed up for my channel for other easy videos delivered right to your inbox.
Hi digglerinho, I am glad it worked for you and helped so much. I will have to try this concept in 2013 so it will be interesting to see how it works in that version. Thanks for the tip. Steve=True
Wow this was perfect, thanks so much for the clear tutorial! Helped me with my IT chart showing number of failed and succeeded jobs by client, for each month!
Great video, very helpful! One note, if you want the grid lines to continue throughout the graph you can actually delete the "filler" column itself and the grid lines stay consistent across the "white space" on the graph.
Wow! dude... u saved me in my data visualization class.. I would add one more information to this... If you do not want your grid line to be broken.. then click on the while fill and set the transparency to 100%
Cheers!! Did help me a lot. Strangely though I didn't have to press the switch rows columns button (in Excel 2013). Used years instead of products, so I had around 20 in this category, maybe this changed it? Anyway keep up the good work.
Thank you so much! At first, I tried using the staggering method, which sort of worked, but I couldn't reduce the gaps between the data markers to create "clusters." This helped so much!
Thanks for the tips. It would be a lot easier if you actually selected "No Fill" for the white column. Then you could accommodate alternative background colors/pictures for your chart/slide.
Thanks Exceldashboards - appreciate it! I ask because one of my work colleagues had chided me some months ago for struggling to create graphs in Excel and then copy/paste them over into Word. "Why not just do everything in Word...? It's so much easier?" she laughed. I was mortified. That, and I've noticed that if you copy/paste from Excel to Word, and then send your Word doc, the data may not transfer over making it difficult to edit. Have you found this too/found ways to get around this?
Hi Laura, you can make a 3D stacked column chart, but I would recommend against it. Also, you cannot group like this in a 3D chart. Good luck. -Steve=True
Hi Rollingcabbage k. Yes you can tier a lot of data. Go to my blog and check out a post titled: "Case Study Solution - Mom Needing Help on Science Fair Graphs/Charts". There is also a video attached. This brings up a good point that you should also sign up for my blog as the related posts sometimes have other links and more information than can be provided in the video. For instance, I have link to the other post in my original article. Thanks for being a fan! Steve=True
Hey - can you make this chart when starting from MS Word? I've noticed that when doing it this way Excel won't let you select which data you want to use (i..e, you must use the first row and column).... ???
Love this! Just what I needed. Now, how would I add a line plot showing the ration between each cluster? Do you have an email I can send you a picture of what I mean?
+Sean Howard Hi Sean, Thanks for the great comment. Glad you love it. Thanks for going to my website and submitting a contact form. I have replied to your email. Hopefully I can help. Steve=True
You continue to amaze me. I've made charts like this before, but not with the white separator between groups. Most of my users are amazed enough with separating the groups. EXCELent!
Fantastic - thank you!! Clunky that we should have to "trick" Excel like this. You would think that they would have got their heads around this by now.
But, no, awesome - thank you for thinking outside the square when I no longer have time to!!
OMG!!! I think you just saved me my job!!! I mean it's not that serious but I didn't know it was that simple to make what I needed!!
You are welcome. So glad it helped!
Helped me with actual problem that took me hours. I now learned about the 100% chart and switch/row column thank you !
Awesome. Great to hear. So glad to help. Thanks for your comment!
Thank you so much for your video. I was stuck trying to create a graph exactly like the one you are showing. You helped me SO much, you really made my day. Thanks!!!!
Thanks Sam!! I really appreciate the feedback and likes. Steve=True
Hi Steven, not sure if you can do this when starting from Word. That has limited options. I would recommend making your chart in Excel and then copy/pasting special your chart into your Word file. I will have to do a post to show you how in the near future. Thanks for the question.
THANK YOU THANK YOU THANK YOU!!!!
I was struggling with this for hours, and couldn't figure it out. Thanks! :D
You saved me!!
+Mahdie Najafi You are welcome.
I was mind effed when you made the white fill split the graph. thank you so much for this.
Thanks for the great comment :)
Thanks so much. I was just wondering how to create a combination of clustered and stacked charts, and it helped me a lot. Wonderful, Thanks once again
I knew it, I knew it... I KNEW IT!! I knew this type of presentation must have been out there, but after viewing multiple vids this is the only one I found that demo's it!!! Kudos! One additional tip: In 2013 you can select individual sections of the bar graphs and make them custom colors. Thus in this example you could change the entire Budgeted column into hues of green, and the entire Actual column into hues of red. It's a bit of effort but can be quite visually distinctive!
Adam Joseph Thanks for the great Comment Adam and the great tip! Much appreciated. Steve=True
This was a huge help for me. Kudos on an easy to follow demo.
This was exactly what I was looking for! Thanks!!
Thanks for the great comment Danielle. Much appreciated and so glad that it was exactly what you needed. Steve=True
Really simple and very well explained...thanks a lot..saved me a lot of time.
Thanks Gautam, I am very happy it worked for you. Steve=True
great, simple and easy to create. Many thanks.
Awesome, I am so glad this Excel Tip and Trick worked for you! - Steve
Thank you for making this really easy to follow.
Thanks Yvette, you are welcome. So glad it was easy. Steve=True
Thank you! This is exactly what I am looking for. No need to pay costly consultants for this requirement. Great Job!
iammarzhie You are welcome. Glad to help iammarzhie. But I am a consultant, so maybe I should take the post down :) lol Thanks for the nice comment. Steve=True
exceldashboards This works almost perfect. Just one more minor concern is that how to secure the category label at the center. I have tried to format the source data but it's not working (multi-level category level box is already ticked). Maybe you could help me. Thanks in advance!
iammarzhie Hi iammarzhie, not sure your exact problem. If you want the center to show the tick mark, enter a space in the spreadsheet cell that would normally hold a category. Hope this helps. Steve=True
Nick, thanks for the nice comment and I am so glad it was easy. Hopefully you signed up for my channel for other easy videos delivered right to your inbox.
Hi Azad, Thanks for the GREAT comments. You are most welcome. I am so glad that it helped. Steve=True
Hasz, you are quite welcome. Thank you for the nice comment! - Steve
You are the best!!! Have seen multiple videos on this topic. Thank you soooo much!!! This is really what I was looking for!
Thanks, you made me a happy camper! You are welcome. Glad to help!
Awesome, really helpful, been trying to figure this out for ages!! Thanks
You just saved my ass with this video! I have a cool graph now that shows exactly what I want! Thanks a million
Wonderful. So glad to help. Thanks for the comment.
Hi digglerinho,
I am glad it worked for you and helped so much. I will have to try this concept in 2013 so it will be interesting to see how it works in that version. Thanks for the tip.
Steve=True
Wow this was perfect, thanks so much for the clear tutorial! Helped me with my IT chart showing number of failed and succeeded jobs by client, for each month!
+Jen Small Awesome, so glad to help.
you.. my man!!!! that space to delineate the columns were so helpful! THANKS
So happy to help! thanks for the great comment
Thanks Muthusaravanan. What a great comment. You are welcome. Glad to help. Steve=True
Great video, very helpful! One note, if you want the grid lines to continue throughout the graph you can actually delete the "filler" column itself and the grid lines stay consistent across the "white space" on the graph.
***** Thanks Chris, I added the filler column as a design element. It is definitely not needed. Thanks for the great comment. Steve=True
Hi pooja jain,
Thanks for the great comment. I am glad it helped.
Steve=True
Thanks buddy, couldn't get the axis labels to look clean you had here. Will definitely help tomorrow.
Glad to help. Thanks for the comment!
You just helped me to help my girlfriend (tech spass) to analyze the gravegood composition of bronze age mounds. Thank you!
Interesting use case. So glad to help. Thanks for the comment!
ZhanaV, you are welcome and thanks for the great comment dude.
Steve=True
Thanks for the video, much appreciated. Gave me great assistance in my English assignment. Thanks!
+Wixydoug Gaming Glad it helped. Good luck in English. Steve=True :)
Thank you! Thank you! I had to turn a project around in 10 min and was clueless as to how to do this. Done!
thowgo You are quite welcome. Glad to save you time and help you out. Thanks for being a fan. Steve=True
this really saved my butt today. thanks.
Awesome, I am so happy to save you. Steve=True
Wow! dude... u saved me in my data visualization class..
I would add one more information to this...
If you do not want your grid line to be broken.. then click on the while fill and set the transparency to 100%
Thanks Aravind. You can also just omit that entire series and not add it in the first place. It was a personal preference for me.
You are very welcome. Thanks for the great comment!! - Steve
Thank you so much for this! It helped me to make something I couldn't figure out how to do.
Miroslav Kis Hi Miroslav, you are quite welcome. Steve=True
Thankyou so much,you saved my day in 9min,much appreciated
Thanks for the Great comment! Much appreciated
Hi fdski1,
Thanks for the awesome comment. And yes, it is "Excel"lent stuff :) Thanks again for being a fan!
Cheers!! Did help me a lot. Strangely though I didn't have to press the switch rows columns button (in Excel 2013).
Used years instead of products, so I had around 20 in this category, maybe this changed it?
Anyway keep up the good work.
Thanks so much, this was easy to follow and implement as you were instructing.
Paige, I really appreciate the feedback. Thanks
Thanks a Tonn!! This video has helped me a lot..!!!
great concise presentation, thanks!
Claude Pelletier Hi Claude. Thanks for the great comment. It is greatly appreciated. Steve=True
Thanks for the awesome comment David B.!!!!
Thank you so much! At first, I tried using the staggering method, which sort of worked, but I couldn't reduce the gaps between the data markers to create "clusters." This helped so much!
gmashe, thanks for the awesome comment. Excel is a great tool, but sometimes it needs help :) - Steve
Very helpful tutorial. Thanks for sharing.
Mark Anchondo Mark you are very welcome. Thanks for the amazing comment. Steve=True
You just saved my life, thank you!
You are welcome. So glad to help!
Excellent stuff. Thanks a lot !!!!
Thank you so much! This was so easy to understand.
You are welcome. Thanks for the great feedback!
This is awesome dude... appreciate your help.. you made my day
Exactly the information I was looking for, thanks!
Wonderful. You are welcome.
Thank you ! Just what I need
Hashby Chavez Hi Hashby, so glad to help. Thanks for the great comment. Steve=True
you just saved my presentation !!
Awesome Rebecca, so glad to help! Let me know how the presentation went. Hope you get a promotion out of it.
Thanks for sharing. Nice tutorial.
Luis Sibira Thanks for the awesome comment. Much appreciated. Glad you liked it. Steve=True
thank you, helped me a lot
LEGEND! Thank you so much, great tutorial.
Amazing! And so interesting to learn.. Looking forward ti many more interesting stuff
Thanks for your great comment
Awesome!!! You did great.
Thanks for the tips. It would be a lot easier if you actually selected "No Fill" for the white column. Then you could accommodate alternative background colors/pictures for your chart/slide.
Thanks Athena, yes, that would be a good idea. Steve=True
Thank-you, so helpful.
Glad to help. thanks for the nice comment.
Duke, you are welcome.
Thank you so much for this!
You are welcome. Thank you for the great comment.
It helped a lot. Thank you
+C Alleyne Glad to help. Thanks for the nice comment.
Awesome; if you change the transparency on that WHITE FILL to 100%, the horizontal grid lines will show through and the chart looks even better.
Hi Geoff, yeah, it is a user preference. The white column is not needed at all and you can just delete it if you prefer vs transparency.
Thank you very much. Your clip is so helpful :)
So glad it was helpful Tuyet. Thanks for the great comment. Steve=True
Very useful, thank you!!
So glad to help Giulia Santulli Sanzo. Thanks for the great comment. Steve=True
Thanks Exceldashboards - appreciate it! I ask because one of my work colleagues had chided me some months ago for struggling to create graphs in Excel and then copy/paste them over into Word. "Why not just do everything in Word...? It's so much easier?" she laughed. I was mortified. That, and I've noticed that if you copy/paste from Excel to Word, and then send your Word doc, the data may not transfer over making it difficult to edit. Have you found this too/found ways to get around this?
You have been of great help. Very neat presentation on using graphs...really helped me a lot.
Thanks Lops, glad it helped. Steve=True
Great! Helped a lot.
Hi Bobby, thanks for the great comment!! So glad it helped you. Steve=True
so helpful!! thank you!!!
You are welcome. Thanks for the great reply.
Hi Laura, you can make a 3D stacked column chart, but I would recommend against it. Also, you cannot group like this in a 3D chart. Good luck. -Steve=True
thanks very much! i;ll check it up later
Hi Rollingcabbage k. Yes you can tier a lot of data. Go to my blog and check out a post titled: "Case Study Solution - Mom Needing Help on Science Fair Graphs/Charts". There is also a video attached. This brings up a good point that you should also sign up for my blog as the related posts sometimes have other links and more information than can be provided in the video. For instance, I have link to the other post in my original article. Thanks for being a fan! Steve=True
Great video!
Thanks!
Superhelpful, you saved me :) Thanks so much...
Nevena Ciric Thanks Nevena. I really appreciate the great comment. So glad to help and save you time and effort. Steve=True
Thanks for the video, very helpful
You are very welcome. Thanks for the nice comment.
Very clever. Thanks.
+Daniel MacDonald Thanks Daniel for the nice comment. Steve=True
thanks from chinese.:)in china, i search around we don't have this simple way to do this work
不客气bú kèqi
So amazing video! That's I want!
Ting Su So glad I can help. Thanks for your comment. Steve=True
Thanks Kannan.
Thanks.! Question what if we want the act in different shade if colors compred to bldg?
thanks man excellent video
Thank you, I appreciate the kind comment.
Very useful.. thanks for the video
+erwanza nirwan Thanks for the great comment. Glad to help!
what if there are four sets of data in Act column, and three in Bug, is it still possible to do a side by side stacked columns as shown in the video?
Thank you!!
You are most welcome Jessie.
Hey - can you make this chart when starting from MS Word? I've noticed that when doing it this way Excel won't let you select which data you want to use (i..e, you must use the first row and column).... ???
Thanks a lot!!
You are welcome!
Thanks
awesome...thanks
Thank you, that's so helpful!!!! Any idea why Excel presents the data in the chart in reverse order to the table? I'm using 100% stack bar charts
I've worked it out, a reverse category in the axis settings. My charts look great, thanks again
You are welcome. So glad you worked it out.
Just submitted my separated stacked columns for 5 different states. Gotta say thanks a lot. If I may ask though, how many columns can one plane take?
You are welcome. Charts can only have 255 series so that would be your limit.
Is there a way to make the blank column thinner (less wide)?
Thanks a lot mate
You are welcome. Thanks for the nice comment
Thanks!
You are welcome
Thanks!!
You are welcome. Thanks for the comment Adria
Cool man... thank you
Thanks Kourosh. Glad you liked it. Steve=True
Love this! Just what I needed. Now, how would I add a line plot showing the ration between each cluster? Do you have an email I can send you a picture of what I mean?
+Sean Howard Hi Sean, Thanks for the great comment. Glad you love it. Thanks for going to my website and submitting a contact form. I have replied to your email. Hopefully I can help. Steve=True