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 RUclips 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...
Thanks Mike! Just finished watching your comprehensive Excel for Math intro video. Love the color convention. Learning Excel couldn't be made simpler :)
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: ruclips.net/p/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs
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
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).
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.
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.
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 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.
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?
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.
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?
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.
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 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!
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?
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?
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...
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.
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
Have created a similar stacked graph and eliminated several of the items from legend as shown. Have a more complex graph and copied the first one as a template, however, now wish to add items to the legend. Deleting is obvious, how do you add items to the legend?
@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 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.
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?
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?
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?
If I have high and low numbers in different periods you said add the Min value as you did when adding the invisible value, yet I get an error when doing so saying "error in formula" Make sure you've included all the required parenthesis, verify any reference to another sheet, avoid an equal or minus sign. I did the same formula and tried adding the same. specifically how do I add that parameter to the primary axis.
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 :)
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.
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.
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 RUclips 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.
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
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 :)
Really excellent! Saved my bacon on a deadline! You are very smart with Excel, Leila!
Glad it was helpful!
Ah. MAY. Zing. Fantastic solution to this problem which has been plaguing me all morning!!
Happy to help :)
I think I am in love - brilliant video.
One of the best RUclips 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: ruclips.net/p/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs
You genius 🤓 I needed it badly today
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
BIG THANKS for all of your great videos!! I have learned so much!! Really very useful ideas and tools, thanks!!
Glad you like them!
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).
This is way too awesome. Thanks Leila. Appreciate it.
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 RUclips 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.
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!
This was so helpful!! I have used this multiple times
Thank you so much!!! I wrecked my brain to figure out this graph for my boss.
Glad it helped!
OMG thank you! This saved me such a headache.
Great Video. Easy instructions to follow. thsnks
This was exactly what I needed 🤩
Happy to hear that :)
This is such a useful video, thank you for helping me find a solution.
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 :)
Fascinating. Very complex--and useful.
Thank you Oz :)
Great demonstration .. Really helped me a lot ...
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.
Do you have any video on how to bring the series names inside the bars in a clustered bar graph?
Interesting challenge and awesome solution. Always thinking out of the box. Thank you, Leila!
You're very welcome Celia! Thank you for your comment :)
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 :)
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. 😉
You are a saviour!!
Thank you so much!!
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.
Well done. Easy to understand both visually and audially. Thank you
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.
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.
Amazing Leila. Very Helpful and I will use it at my work for Quarterly Summery.
Great! You're very welcome John.
Useful and helpful tutorial. Big thanks!
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 , 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 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.
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
Hi Leila, Thanks is helpful. Also i am looing for stacked waterfall chart. Can you please share the same. Thanks once again
Great chart and as always great explanation
Thank you Vida.
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?
like this .. I've learned many things from this video. Thanks v much
Glad to hear that!
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.
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 :)
Thank you!!
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?
Love this video 💕
Thanks LG
This one is very unique topic
Thank you Dev! Glad you like it :)
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.
Thank you so much for your tutorial.
highly useful thank you to share your knowledge with others
thanks so much for this - exactly what I needed and explained so clearly!
Glad it was helpful!
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.
Outstanding!!
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 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!
It is possible doing this in power bi ?
I love it your video. Simple and clear to follow it.
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?
Amazing
I love you!
thanks for sharing!
how do invert the total for a bar. e.g. 500 on top 2000 bottom
Awesome Leila! This is the solution I am looking for. 5:57 "Why did it do that?", so cute
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...
U are so helpful I can't thank you enough. 👍
You're very welcome Hernan!
Is there a possibility of getting a 3rd or 4th stack clustered bar 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?
Amazing! Thank you!
Glad you liked it!
I can put Data Label for each stack inside top but then how to put Cumulative figure of Data Labels in a stack on outside top?
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...
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.
Interesting, could you please make a tutorial for the same with Power BI?
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
Hello. How can I add a percentage line? I am finding it hard to do since it has already a secondary axis. Thank you
Your are a genius!
😘
Hi Leila, could you show us how to overlay 2 radial bar charts- it would be very helpful for me at work🙏
Thank you.. i was looking for this solution so much !!
Have created a similar stacked graph and eliminated several of the items from legend as shown. Have a more complex graph and copied the first one as a template, however, now wish to add items to the legend. Deleting is obvious, how do you add items to the legend?
How do you show cumulative/additive stacking rather than one in front of the other/overlapping?
@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!
Thanks Leila for this video & information
Is there a way to also have 3 number sets of data stacking along with clustered visibility ?
Thank you so much. The VDO is very useful I actually utilize it for presentation.
That’s great. I’m happy to hear that.
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.
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 muchhhhhh!!!!! You are GREAT!!!!!
You're very welcome :)
This is one's good. Thanks Leila
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?
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?
thanks a lot, it helps me
Can I do this with excel 2021? …so far it does not work. Also, could this work if I create this chart from a pivot table?
If I have high and low numbers in different periods you said add the Min value as you did when adding the invisible value, yet I get an error when doing so saying "error in formula" Make sure you've included all the required parenthesis, verify any reference to another sheet, avoid an equal or minus sign. I did the same formula and tried adding the same. specifically how do I add that parameter to the primary axis.
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...
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
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.
How to add line graph in this and add a third axis