Create charts that wow your audience. Learn the secrets now-start today! 👉 link.xelplus.com/yt-g-stacked-charts-course Grab the file I used in the video from here: pages.xelplus.com/column-chart-file
@monink980 - my secondary bar chart is higher than primary bar chart. I added Inv value 2 times and didn’t fix the problem. Do you know how to show the 2nd bar chart not overlapping the primary bar chart in stacking?
I was so glad when I saw your face when I did a TH-cam search on this very topic! I was struggling to get cluster stacked charts to work and I was going about it the wrong way! You've been a constant reliable source for my Excel development and I think you for all that you do.
Once again, a Big salute to my beloved Excel Teacher, no words to praise your teaching method.I Pray the almighty to give good health, to my beloved/beautiful Teacher to do more Excel Videos in future for the benefit of all the Excel learners/users/addicts.--Big Royal Salute.
Thanks a lot Excel Guru/Teacher. I am very much benefited by your videos in learning skills/tricks.I pray the almighty to bestow good health & prosperity in every walks of life.
Hi Leila, I'm a PICU doctor with zero computer skills! I've been trying to make the routine data we collect "sing"! Your videos have been invaluable - Thank You...
Thank you so much for the video @Lelia Gharanti. Can you show us how to fix the secondary bar chart (5) overlapping the primary bar chart (4) in stacking? I did two of inv values. Still didn’t work
Wow! That's a very nice comment! Thank you! Anything special you're looking for regarding arrays? I have some videos in this playlist here: th-cam.com/play/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs.html
Hi Leila, your videos and tips n trics are very informative and useful. I have a question - how to create two 100% stacked bar charts in single graph? Is there any work around? It would be very helpful to know.
Thanks Mike! Just finished watching your comprehensive Excel for Math intro video. Love the color convention. Learning Excel couldn't be made simpler :)
Leila, You are Awesome at excel, love the tutorial. The best part about your videos, is your explanations are clear and easy to understand. Do you know in this example if excel allows you to put the total portion on the bottom and the apps portion on top? I tried to inverse the series that you would select to the secondary access, but no go. :(. Again Thank you you're awesome.
Another beauty created by you. I am a data visualisation guy and I love to learn new techniques in data visualisation. I use Tableau very often but I think you create very useful charts fitting the use cases of many problems. I also refer to some other you tube channels for Sumit Bansal (Trump Excel) & Chandeep (Goodly). I also have my own You Tube channel and am currently creating videos for basic Excel as of now but will soon move into the advance Excel concepts and features and go upto Business Intelligence tools as I am a full time faculty for a B-School in Mumbai and teach subjects related to Analytics. Your channel is a great inspiration to me. Thanks once again.
Leila Gharani thank you for your kind words . Look forward to associate with you on this platform. It has been a great learning so far and hope it goes on the same way.
Leila good morning > I find this video very hope full. The way you explained I can follow you very well. Every day i become more interested in your video.
Is it possible to add labels to both stacks and the total? I haven't been able to figure this out and have been manually adding a label to the second stack.
Using Mac Excel...It wouldn't allow me to change the series chart type for inv.Value to line because the secondary axis already has multiple series with chart type defined as clustered column (like you showed). The error says "Some chart types cannot be combined with other chart types. Select a different chart type." There aren't any other chart types that work, and choosing the "combo" option just makes one axis column and the other whole axis (all series) line. That makes me think it's restricting to 1 chart type per axis--so I'm not sure how you did it unless this is a Mac-specific limitation. It worked to instead match the axes manually like you mentioned. It could also be that this method doesn't work for horizontal bar charts? I couldn't get any of the columns to line up in the same order across categories--but it worked when I switched back to vertical bars. I'm also curious if there's a way to do this with "true" stacked columns so that you can show accurate labels for each of the sections of the column. i.e. Doing it this way, you can only show labels for the small portion (new apps) and the total (all apps), but not the large portion (existing apps).
Thanks Leila, it's an amazing tutorial. i am very happy to learn from your tutorial. The way you explain is very simple and awesome. please keep uploading more excel stuff.
Thanks so much, I almost got it working but might be doing something wrong. When I tried this, the columns stack behind each other (from the bottom axis), instead of stacking on top of each other. Is there a way to fix that?
Thanks Leila, but I'm struggling to force my secondary Y -axis ( in %) to always start from 0, on a Power Pivot combo chart. My primary y-axis always may have negative values when the pivot changes, can you do a video explaining this?. can write DAX measures to determining max etc. but need to align primary and secondary axis to always start from 0 dynamically.
I am hoping to create a stacked/clustered bar graph that shows actual daily progress but also compares it to the weekly plan for that activity. Say I have four items. I would have a bar representing weekly planned amount and a stacked bar below it showing actual daily progress. I need this for each item. Would you happen to know how to do that? Any help would be greatly appreciated! I have learned a lot from your videos!
Thank you for this video, its very helpful and the way you explain it in simple is great to understand. I have one pivot table with data how do I convert this data into a readable chart which works in presentation as well, I have to report this data in the presentation.
Thank you for the video. I replace Q1, Q2, Q3, Q4 with locations. I also have month to month data on top of product sold and sales price. And then I have 3 types of product sold with 3 types of sales price. How do I built such data?
Hi Leila First of all, the way you present is truly simple and easy to understand. I was trying to create a chart, which is a combination of Clustered plus Stacked Column Do you already have a video for that? If not Please need your help. Not Sure how to insert files into this comment. Else, I wish to give an example.
@Leila Gharani Thank you so much for the very informative tutorial! I have just one question. around 6:27 you mention the possibility of the primary series to be smaller than the other. If that is the case, then the bigger column will cover the smaller one. How can one solve this issue? Again thank you so much!
Hi Pietro - You're very welcome. You can get around this by adding an invisible point, like I did here - but you can add that point to both the primary and the secondary axis...this will make sure that they are always in-sync.
Thanks for the reply! I also found another way (not sure how intuitive), by colouring the bar with a gradient. Example: tot n projects 10, of which 3 have been given a score of 1, 3 of 0.5 and 4 a score of 0. So now we have 3=30%; 3=30% and we leave the 0s out. Since the total would be 60% I created a bar chart where for that specific bar I put 60%. Then I take the proportion of 30% and divide it by 60% (=50%). At that point if you move on format data point on PPT you can just put both gradients at 50% under 'position'. It's a bit tedious - especially if you have to do it with a lot of bars, but I found that it also works. I guess you're method is probably quicker than this though. In any case thank you for taking the time to answer my question!
Hi , on top of these, i need to add a line chart for another set of data for the same period. Is there a workaround since the secondary axis is already utilized
Thanks for sharing such a great knowledge, I hope you can help me. I want to send multiple excel charts through outlook which I have created after watching your excel videos but it doesn't fit properly. I mean I want to send it like it is in excel dashboard but its very difficult. Hope you will sort this out for me.
Thank you Leila, the video is really helpful, I have a similar problem but i have 2 sub categories in 1 category eg -P-newapp1 & P- newapp2. can this be solved using this technique?
Thank you so much for your quick response. I have a question Create a combo chart only for a specific name: Horizontal axis label range: Date First data series range: Duration with a value of Carvallo in the name column Second data series range: Charge with a value of Carvallo in the name column Type: Combo chart Duration series: Clustered column (Primary axis) Charge series: line (Secondary axis) Name Date Time Duration Charge Carvallo james carvallo sarah
Hi - I'm not sure about the question here...maybe you can post it either here: www.mrexcel.com/forum or here: www.excelforum.com/ - you can post a link to your question here too and if I get a chance I can take a look, otherwise you will get answers from others...
Thank you so much for your tutorial it was very helpful. I took excel expert but I was not able to create the dual axis chart. the chart has the primary axis as column and the secondary as line. the chart has to show only where the two chart has value but if the secondary has 0 as value don't show the column data of the primary. Thank you so much.
You should be able to set different min and max values for primary and secondary axis. Make sure your line chart is really based on secondary and adjust the secondary axis values. I can't see why it wouldn't work....
Leila Gharani , thank you so much for this helpful video. Is it possible to create one stacked bar on the primary axis (with two values), and another stacked bar on the secondary axis (with two values), but with space between them? I have two data sets with very different value ranges, but I would like to display them in the same chart.
In your case, your are able to "trick" excel since you have 2 bars in one stack. What happens if you have 3 bars or more in each stack. What do you do?
Had a bit of trouble getting mine to look like yours. I have 3 sets of data. One total sales, 2nd cost of sales, 3rd over heads. All in per month. Wanting to stack the cost of sales and over heads and then have that column beside the total sales.
For those who tried and the bars are not overlapping perfectly - right click on the bars, click on format data series, and make the series overlap to 100%
Question - Is it possible to do three stacks? It seems like since there is only a primary and secondary axis, it doesn't seem possible to add a third stack since there is not a 3rd horizontal axis?
At 8:17, the first column on the left shows two overlapping bars of 500 and 2000. Wouldn't a stacked bar total to be 2500, instead of the 2000 bar as shown at 8:17. This leads me to believe that this is not a stacked bar, but is instead two overlapping bars.
How can i make a 3 level stacked - 2 column chart. I have data for number of manpower for electrician, mechanic and plumber distributed by months having the baseline and actual values. I want to see the difference between the baseline and actual per month in a chart. Thank you.
Leila, what happens when the values from one axis are close to the values from the other I find that as they vary from greater than or less than in each column, I lose visibility of the one of the axis. Is there a resolution for this? Is the only solution to vary which column is on which axis, manually? Also how do you create a gap between each column?
Leila Khanoom, I have 2 products (X and Y) whose sale that I would like to trend for each month of 2018 and 2019. For example total sale in Jan 2018 next to total sale in Jan 2019, but show it in stacked bar, so I can not only show total sale comparison of Jan'18 and Jan'19, but inside the bar I can show product mix as well (X and Y). I have 2 years, 12 months per year and 2 products. I also need to show TOTAL sales (X + Y) on top of each bar for each month (Jan - Dec). How do you suggest I format my excel table? Merci, Mehran
My ebook is free - you can get it from xelplus.com. It's not about charts though. You'll find my charts course here: www.xelplus.com/courses/ It's great that you took the Expert exam!
this is good, except if you wanted to label each of the 3 bars within the quarter and then have the legend represent values for the various stacks inside each bar, then how would you do that? I have a way of doing that which really impresses everyone at work, but interested to hear your view.
Thanks - I'm not sure about the part "have the legend represent values for the various stacks inside the bar" - do you mean the chart legend? I am curious about your method ....
i can email you a sample if you want. Maybe that'll get me a bonus points :) It's not super complicated and allows you to have unlimited bars and stacks within the bars basically.
Thank you Leila! quite a few steps to accomplish your goal. I did not realize this was a way. Maybe you could make a part B where you use reorganizing your source data? For example what if the division values are NOT excluded for the new apps, or that the order is different?, or that you have a division, new apps and a new group (like "very new")? I think in these cases you better modify your source data? Greetings, Bart
You're welcome Bart - That's a good point. I'll add one that needs a bit more organizing and also has more than two stacks. This technique just works with two stacks only. Regarding the step chart - this happened to be the longest video I recorded (it came to around 40 minutes (raw recording)) - so unfortunately no time to do the final editing this year. It will be in January though :)
madam you are simply great... i am following many videos, they are simply great... Plz help in developing a 3D chart with stacked column where z axis is Controllable, i am not getting the Z axis options to control.
Thank you. I'm glad you like the videos. Not sure about the Z axis. I'm not a fan of 3d charts. They're very difficult to read by users. How about using two separate charts beside one another instead?
Hi Leila I Purchased your Excel charts course from Udemy. I just wanted know about overlap series.. So my question is if we have 4 series which gets overlap first.. wo we have our control on series overlapping.. kindly suggest.
Suppose Productivity has two parts; P-new apps 1 & P-new apps 2. In that case, we always need to show the new apps values as Stacked Chart on the Secondary Axis with Productivity Values as Clustered Column on the Primary Axis. My question is, if I add 3rd series on Secondary Axis using maximum of values to make the scales same, will it work? At the moment it is not working. Would you mind explaining how can I make the Primary and Secondary Axis Scales the same when I have two parts of Productivity Values?
in this example if i need to get p -new apps bar above the productivity - how do i do ? example 2000 dark blue is below and 500 (light blue) is on top of the dark blue ?
I m so happy and excited to find your video. I can't wait to get your visual basic book. I all the time wanted to learn VB coding. I work with MS Access and MS excel a lot. I have created a form in excel where I send to all the regions to fill out and email it to me back. but they don't fill out all the fields in the form. how to make a fields required? and how they can open it as a Form to fill it out and fill out the required form. Thanks in advance.
Thanks! I'm happy to hear that. You can create userforms with VBA and make fields mandatory so they can't submit the form if those fields are not filled. I do that in the course for the last tool that we create (it's an invoice generation tool). Maybe something like that would help for your case.... A VBA free alternative, might be to use conditional formatting. Fields that not filled, could get the color red until they input there.
Create charts that wow your audience. Learn the secrets now-start today! 👉 link.xelplus.com/yt-g-stacked-charts-course
Grab the file I used in the video from here: pages.xelplus.com/column-chart-file
This video helped me two times in less than four months. Microsoft office developers should really add a stacked bar chart.
@monink980 - my secondary bar chart is higher than primary bar chart. I added Inv value 2 times and didn’t fix the problem. Do you know how to show the 2nd bar chart not overlapping the primary bar chart in stacking?
I was so glad when I saw your face when I did a TH-cam search on this very topic! I was struggling to get cluster stacked charts to work and I was going about it the wrong way! You've been a constant reliable source for my Excel development and I think you for all that you do.
Once again, a Big salute to my beloved Excel Teacher, no words to praise your teaching method.I Pray the almighty to give good health, to my beloved/beautiful Teacher to do more Excel Videos in future for the benefit of all the Excel learners/users/addicts.--Big Royal Salute.
Thank you very much Gopala. Glad you like the videos. Wish you also all the best and will do my best to keep this up in the future :)
Thanks a lot Excel Guru/Teacher. I am very much benefited by your videos in learning skills/tricks.I pray the almighty to bestow good health & prosperity in every walks of life.
Hi Leila, I'm a PICU doctor with zero computer skills! I've been trying to make the routine data we collect "sing"! Your videos have been invaluable - Thank You...
It's great you are developing new skills! I'm really glad I can contribute a little to that.
Thank you so much for the video @Lelia Gharanti. Can you show us how to fix the secondary bar chart (5) overlapping the primary bar chart (4) in stacking? I did two of inv values. Still didn’t work
YOU'RE MY ANGEL.. I JUST SPENT 1 HR TO DO WHAT YOU JUST SHOWED ME.. THANK YOU
I'm very happy to hear that! Thank you for your comment. Hopefully next time it will just take a few minutes :)
One of the best TH-cam channel to learn excel . The way you explain it is simply awesome .Could you please upload some videos for array function ?
Wow! That's a very nice comment! Thank you! Anything special you're looking for regarding arrays? I have some videos in this playlist here: th-cam.com/play/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs.html
Really excellent! Saved my bacon on a deadline! You are very smart with Excel, Leila!
Glad it was helpful!
So you have an explanation of "activating" charts? I've never heard of this before. Excellent video as we've come to expect from you.
Ah. MAY. Zing. Fantastic solution to this problem which has been plaguing me all morning!!
Happy to help :)
This is such a useful video, thank you for helping me find a solution.
Hi Leila, your videos and tips n trics are very informative and useful. I have a question - how to create two 100% stacked bar charts in single graph? Is there any work around? It would be very helpful to know.
I think I am in love - brilliant video.
Very cool Secondary axis and line too : ) Great Tricks!
Thanks Mike! Just finished watching your comprehensive Excel for Math intro video. Love the color convention. Learning Excel couldn't be made simpler :)
Thank you for your kind words!
@@LeilaGharani thats the true spirit
Leila, You are Awesome at excel, love the tutorial. The best part about your videos, is your explanations are clear and easy to understand. Do you know in this example if excel allows you to put the total portion on the bottom and the apps portion on top? I tried to inverse the series that you would select to the secondary access, but no go. :(. Again Thank you you're awesome.
Hi Leila, could you show us how to overlay 2 radial bar charts- it would be very helpful for me at work🙏
Another beauty created by you. I am a data visualisation guy and I love to learn new techniques in data visualisation. I use Tableau very often but I think you create very useful charts fitting the use cases of many problems. I also refer to some other you tube channels for Sumit Bansal (Trump Excel) & Chandeep (Goodly). I also have my own You Tube channel and am currently creating videos for basic Excel as of now but will soon move into the advance Excel concepts and features and go upto Business Intelligence tools as I am a full time faculty for a B-School in Mumbai and teach subjects related to Analytics. Your channel is a great inspiration to me. Thanks once again.
Thank you! You have a great TH-cam channel! Keep it up. Looking forward to the BI tutorials :)
Leila Gharani thank you for your kind words . Look forward to associate with you on this platform. It has been a great learning so far and hope it goes on the same way.
Well done. Easy to understand both visually and audially. Thank you
BIG THANKS for all of your great videos!! I have learned so much!! Really very useful ideas and tools, thanks!!
Glad you like them!
This was so helpful!! I have used this multiple times
Leila good morning > I find this video very hope full. The way you explained I can follow you very well. Every day i become more interested in your video.
Hi awesome explanation but if I want to show data values with percentages as well how do i do that in same chart pls help
Thank you so much, Leila. I'm happy to learn with your lessons and I will practice tomorrow morning.
You'd BETTER practice tomorrow or you'll be in trouble. 😊
You're very welcome. Yes - practice is the only way. I'll have workbook uploaded tomorrow. Will let you know once it's there in the comment.
I've added the link to the workbook now in the descriptions - Happy practicing :)
Thanks Leila for this video & information
Is there a way to also have 3 number sets of data stacking along with clustered visibility ?
You genius 🤓 I needed it badly today
This is way too awesome. Thanks Leila. Appreciate it.
OMG thank you! This saved me such a headache.
Is it possible to add labels to both stacks and the total? I haven't been able to figure this out and have been manually adding a label to the second stack.
Using Mac Excel...It wouldn't allow me to change the series chart type for inv.Value to line because the secondary axis already has multiple series with chart type defined as clustered column (like you showed). The error says "Some chart types cannot be combined with other chart types. Select a different chart type." There aren't any other chart types that work, and choosing the "combo" option just makes one axis column and the other whole axis (all series) line. That makes me think it's restricting to 1 chart type per axis--so I'm not sure how you did it unless this is a Mac-specific limitation. It worked to instead match the axes manually like you mentioned.
It could also be that this method doesn't work for horizontal bar charts? I couldn't get any of the columns to line up in the same order across categories--but it worked when I switched back to vertical bars.
I'm also curious if there's a way to do this with "true" stacked columns so that you can show accurate labels for each of the sections of the column. i.e. Doing it this way, you can only show labels for the small portion (new apps) and the total (all apps), but not the large portion (existing apps).
Thanks Leila, it's an amazing tutorial. i am very happy to learn from your tutorial. The way you explain is very simple and awesome. please keep uploading more excel stuff.
You're very welcome Gulshan. Glad you like it.
Thank you so much!!! I wrecked my brain to figure out this graph for my boss.
Glad it helped!
Interesting challenge and awesome solution. Always thinking out of the box. Thank you, Leila!
You're very welcome Celia! Thank you for your comment :)
Thanks so much, I almost got it working but might be doing something wrong. When I tried this, the columns stack behind each other (from the bottom axis), instead of stacking on top of each other. Is there a way to fix that?
Great Video. Easy instructions to follow. thsnks
Do you have any video on how to bring the series names inside the bars in a clustered bar graph?
Despite my last comment though, this can be a great chart combination to show how much of the current budget on each category is being used up. 😉
Fascinating. Very complex--and useful.
Thank you Oz :)
Thanks for making this kind of videos, I watch many videos, it really helped me a lot.. thank u, love your channel and subscribed
Thanks for subbing!
Hi, I have a question, is it possible to add lines to the chart? But not one for the entire graph but four? One line chart for each quarter? Thank you
Hi Leila, Thanks is helpful. Also i am looing for stacked waterfall chart. Can you please share the same. Thanks once again
Great demonstration .. Really helped me a lot ...
I have learned from you Leila, thanks to you and Happy Holidays!...
You're very welcome and thank you for your comment! Happy holidays to you too :)
It is possible doing this in power bi ?
Thanks Leila, but I'm struggling to force my secondary Y -axis ( in %) to always start from 0, on a Power Pivot combo chart. My primary y-axis always may have negative values when the pivot changes, can you do a video explaining this?. can write DAX measures to determining max etc. but need to align primary and secondary axis to always start from 0 dynamically.
You are a saviour!!
Thank you so much!!
I am hoping to create a stacked/clustered bar graph that shows actual daily progress but also compares it to the weekly plan for that activity. Say I have four items. I would have a bar representing weekly planned amount and a stacked bar below it showing actual daily progress. I need this for each item. Would you happen to know how to do that? Any help would be greatly appreciated! I have learned a lot from your videos!
Thank you for this video, its very helpful and the way you explain it in simple is great to understand. I have one pivot table with data how do I convert this data into a readable chart which works in presentation as well, I have to report this data in the presentation.
Thank you for the video. I replace Q1, Q2, Q3, Q4 with locations. I also have month to month data on top of product sold and sales price. And then I have 3 types of product sold with 3 types of sales price. How do I built such data?
Hi Leila
First of all, the way you present is truly simple and easy to understand.
I was trying to create a chart, which is a combination of Clustered plus Stacked Column
Do you already have a video for that? If not Please need your help.
Not Sure how to insert files into this comment. Else, I wish to give an example.
@Leila Gharani Thank you so much for the very informative tutorial! I have just one question. around 6:27 you mention the possibility of the primary series to be smaller than the other. If that is the case, then the bigger column will cover the smaller one. How can one solve this issue? Again thank you so much!
Hi Pietro - You're very welcome. You can get around this by adding an invisible point, like I did here - but you can add that point to both the primary and the secondary axis...this will make sure that they are always in-sync.
Thanks for the reply! I also found another way (not sure how intuitive), by colouring the bar with a gradient. Example: tot n projects 10, of which 3 have been given a score of 1, 3 of 0.5 and 4 a score of 0. So now we have 3=30%; 3=30% and we leave the 0s out. Since the total would be 60% I created a bar chart where for that specific bar I put 60%. Then I take the proportion of 30% and divide it by 60% (=50%). At that point if you move on format data point on PPT you can just put both gradients at 50% under 'position'. It's a bit tedious - especially if you have to do it with a lot of bars, but I found that it also works. I guess you're method is probably quicker than this though. In any case thank you for taking the time to answer my question!
Amazing Leila. Very Helpful and I will use it at my work for Quarterly Summery.
Great! You're very welcome John.
This was exactly what I needed 🤩
Happy to hear that :)
Useful and helpful tutorial. Big thanks!
Interesting, could you please make a tutorial for the same with Power BI?
Hi , on top of these, i need to add a line chart for another set of data for the same period. Is there a workaround since the secondary axis is already utilized
Hello. How can I add a percentage line? I am finding it hard to do since it has already a secondary axis. Thank you
Thanks for sharing such a great knowledge, I hope you can help me. I want to send multiple excel charts through outlook which I have created after watching your excel videos but it doesn't fit properly. I mean I want to send it like it is in excel dashboard but its very difficult. Hope you will sort this out for me.
Thank you Leila, the video is really helpful, I have a similar problem but i have 2 sub categories in 1 category eg -P-newapp1 & P- newapp2. can this be solved using this technique?
how do invert the total for a bar. e.g. 500 on top 2000 bottom
Thank you so much for your quick response. I have a question
Create a combo chart only for a specific name:
Horizontal axis label range: Date
First data series range: Duration with a value of Carvallo in the name column
Second data series range: Charge with a value of Carvallo in the name column
Type: Combo chart
Duration series: Clustered column (Primary axis)
Charge series: line (Secondary axis)
Name Date Time Duration Charge
Carvallo
james
carvallo
sarah
Hi - I'm not sure about the question here...maybe you can post it either here: www.mrexcel.com/forum or here: www.excelforum.com/ - you can post a link to your question here too and if I get a chance I can take a look, otherwise you will get answers from others...
Thank you so much for your tutorial it was very helpful. I took excel expert but I was not able to create the dual axis chart. the chart has the primary axis as column and the secondary as line. the chart has to show only where the two chart has value but if the secondary has 0 as value don't show the column data of the primary. Thank you so much.
You should be able to set different min and max values for primary and secondary axis. Make sure your line chart is really based on secondary and adjust the secondary axis values. I can't see why it wouldn't work....
Nice video, but these are overlapped columns, not stacked.
It's because she has to fake it out due to Excel limitations.
Left out the most important steps which is u need to trick the excel to change the data so they overlap each other very terrible ms excep
EXACTLY! Thank you!
Yeah, this doesn't work if you have a chart where the data can be higher or lower than the other data randomly. Which is unfortunate.
@@DankiusMMeme Exactly, I tried this on my data set and it looks terrible. Author should mention this very big limitation in video.
highly useful thank you to share your knowledge with others
I love it your video. Simple and clear to follow it.
Leila Gharani , thank you so much for this helpful video. Is it possible to create one stacked bar on the primary axis (with two values), and another stacked bar on the secondary axis (with two values), but with space between them? I have two data sets with very different value ranges, but I would like to display them in the same chart.
In your case, your are able to "trick" excel since you have 2 bars in one stack. What happens if you have 3 bars or more in each stack. What do you do?
Thanks Leila jan
What if we have already used the secondary axis for another chart i.e. we have a line chart showing cumulative sales across quarters?
Thank you so much for your tutorial.
Had a bit of trouble getting mine to look like yours. I have 3 sets of data. One total sales, 2nd cost of sales, 3rd over heads. All in per month. Wanting to stack the cost of sales and over heads and then have that column beside the total sales.
Great chart and as always great explanation
Thank you Vida.
For those who tried and the bars are not overlapping perfectly - right click on the bars, click on format data series, and make the series overlap to 100%
👍
can you have a combination of stacked and cluster column on the same axis? because i have another series that i am plotting on the primary axis.
what an awesome video as always thank you so much and i'm sorry i watched it late because in so busy in work.
Thank you Ismail for your comment. Glad you like it! Of course work is priority :)
Question - Is it possible to do three stacks? It seems like since there is only a primary and secondary axis, it doesn't seem possible to add a third stack since there is not a 3rd horizontal axis?
At 8:17, the first column on the left shows two overlapping bars of 500 and 2000. Wouldn't a stacked bar total to be 2500, instead of the 2000 bar as shown at 8:17. This leads me to believe that this is not a stacked bar, but is instead two overlapping bars.
Yes - correct. That's how you create this type of stacked chart - by using overlapping bars.
very nice information ... but how to put standard error or deviation in this type graph
Thank you!!
How can i make a 3 level stacked - 2 column chart. I have data for number of manpower for electrician, mechanic and plumber distributed by months having the baseline and actual values. I want to see the difference between the baseline and actual per month in a chart. Thank you.
Leila, what happens when the values from one axis are close to the values from the other I find that as they vary from greater than or less than in each column, I lose visibility of the one of the axis. Is there a resolution for this? Is the only solution to vary which column is on which axis, manually? Also how do you create a gap between each column?
could you explain how to create a stacked and non-stacked clustered chart. Thanks!
Is there a possibility of getting a 3rd or 4th stack clustered bar chart?
like this .. I've learned many things from this video. Thanks v much
Glad to hear that!
thanks so much for this - exactly what I needed and explained so clearly!
Glad it was helpful!
Awesome Leila! This is the solution I am looking for. 5:57 "Why did it do that?", so cute
I need to increase the x axis of the excel column chart . I can do the vertical grid line distances not the horizontal between columns
Leila Khanoom, I have 2 products (X and Y) whose sale that I would like to trend for each month of 2018 and 2019. For example total sale in Jan 2018 next to total sale in Jan 2019, but show it in stacked bar, so I can not only show total sale comparison of Jan'18 and Jan'19, but inside the bar I can show product mix as well (X and Y). I have 2 years, 12 months per year and 2 products. I also need to show TOTAL sales (X + Y) on top of each bar for each month (Jan - Dec). How do you suggest I format my excel table? Merci, Mehran
I would like to buy your excel book if you have one. Thanks.
My ebook is free - you can get it from xelplus.com. It's not about charts though. You'll find my charts course here: www.xelplus.com/courses/
It's great that you took the Expert exam!
this is good, except if you wanted to label each of the 3 bars within the quarter and then have the legend represent values for the various stacks inside each bar, then how would you do that? I have a way of doing that which really impresses everyone at work, but interested to hear your view.
Thanks - I'm not sure about the part "have the legend represent values for the various stacks inside the bar" - do you mean the chart legend? I am curious about your method ....
i can email you a sample if you want. Maybe that'll get me a bonus points :) It's not super complicated and allows you to have unlimited bars and stacks within the bars basically.
Sure - I always love seeing different methods :) email is: info@xelplus.com
Thanks - Got it. I'll have a detailed look when I get a chance.
sounds good. hope you like it
Thank you so much. The VDO is very useful I actually utilize it for presentation.
That’s great. I’m happy to hear that.
Thank you Leila! quite a few steps to accomplish your goal. I did not realize this was a way. Maybe you could make a part B where you use reorganizing your source data? For example what if the division values are NOT excluded for the new apps, or that the order is different?, or that you have a division, new apps and a new group (like "very new")? I think in these cases you better modify your source data? Greetings, Bart
You're welcome Bart - That's a good point. I'll add one that needs a bit more organizing and also has more than two stacks. This technique just works with two stacks only. Regarding the step chart - this happened to be the longest video I recorded (it came to around 40 minutes (raw recording)) - so unfortunately no time to do the final editing this year. It will be in January though :)
Leila Gharani : take your time. The longer you wait, the better the result haha...
How to add line graph in this and add a third axis
madam you are simply great... i am following many videos, they are simply great... Plz help in developing a 3D chart with stacked column where z axis is Controllable, i am not getting the Z axis options to control.
Thank you. I'm glad you like the videos. Not sure about the Z axis. I'm not a fan of 3d charts. They're very difficult to read by users. How about using two separate charts beside one another instead?
Love this video 💕
Thanks LG
This one is very unique topic
Thank you Dev! Glad you like it :)
How do you show cumulative/additive stacking rather than one in front of the other/overlapping?
Hi Leila I Purchased your Excel charts course from Udemy. I just wanted know about overlap series.. So my question is if we have 4 series which gets overlap first.. wo we have our control on series overlapping.. kindly suggest.
Thanks mam for sharing such nice and helpful videos....
You're very welcome Ubaid! Thank you for your support and comment :)
You are very welcome mam...but tbh thank you for your support and help...
Suppose Productivity has two parts; P-new apps 1 & P-new apps 2. In that case, we always need to show the new apps values as Stacked Chart on the Secondary Axis with Productivity Values as Clustered Column on the Primary Axis.
My question is, if I add 3rd series on Secondary Axis using maximum of values to make the scales same, will it work?
At the moment it is not working.
Would you mind explaining how can I make the Primary and Secondary Axis Scales the same when I have two parts of Productivity Values?
in this example if i need to get p -new apps bar above the productivity - how do i do ? example 2000 dark blue is below and 500 (light blue) is on top of the dark blue ?
I m so happy and excited to find your video. I can't wait to get your visual basic book. I all the time wanted to learn VB coding.
I work with MS Access and MS excel a lot. I have created a form in excel where I send to all the regions to fill out and email it to me back. but they don't fill out all the fields in the form. how to make a fields required? and how they can open it as a Form to fill it out and fill out the required form.
Thanks in advance.
Thanks! I'm happy to hear that. You can create userforms with VBA and make fields mandatory so they can't submit the form if those fields are not filled. I do that in the course for the last tool that we create (it's an invoice generation tool). Maybe something like that would help for your case.... A VBA free alternative, might be to use conditional formatting. Fields that not filled, could get the color red until they input there.