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.

@sallyho146

25 күн бұрын

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

Well done. Easy to understand both visually and audially. Thank you

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.

@LeilaGharani

6 жыл бұрын

You're very welcome Gulshan. Glad you like it.

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.

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.

@LeilaGharani

6 жыл бұрын

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

@1gopalakrishnarao

6 жыл бұрын

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.

Interesting challenge and awesome solution. Always thinking out of the box. Thank you, Leila!

@LeilaGharani

6 жыл бұрын

You're very welcome Celia! Thank you for your comment :)

One of the best KZread channel to learn excel . The way you explain it is simply awesome .Could you please upload some videos for array function ?

@LeilaGharani

6 жыл бұрын

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: kzread.info/head/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs

Love this video 💕 Thanks LG This one is very unique topic

Very cool Secondary axis and line too : ) Great Tricks!

@LeilaGharani

6 жыл бұрын

Thanks Mike! Just finished watching your comprehensive Excel for Math intro video. Love the color convention. Learning Excel couldn't be made simpler :)

@excelisfun

6 жыл бұрын

Thank you for your kind words!

@kinshukpatil7490

3 жыл бұрын

@@LeilaGharani thats the true spirit

Thank you so much, Leila. I'm happy to learn with your lessons and I will practice tomorrow morning.

@OzduSoleilDATA

6 жыл бұрын

You'd BETTER practice tomorrow or you'll be in trouble. 😊

@LeilaGharani

6 жыл бұрын

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.

@LeilaGharani

6 жыл бұрын

I've added the link to the workbook now in the descriptions - Happy practicing :)

Fascinating. Very complex--and useful.

@LeilaGharani

6 жыл бұрын

Thank you Oz :)

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.

This is such a useful video, thank you for helping me find a solution.

BIG THANKS for all of your great videos!! I have learned so much!! Really very useful ideas and tools, thanks!!

@LeilaGharani

3 жыл бұрын

Glad you like them!

I have learned from you Leila, thanks to you and Happy Holidays!...

@LeilaGharani

6 жыл бұрын

You're very welcome and thank you for your comment! Happy holidays to you too :)

YOU'RE MY ANGEL.. I JUST SPENT 1 HR TO DO WHAT YOU JUST SHOWED ME.. THANK YOU

@LeilaGharani

6 жыл бұрын

I'm very happy to hear that! Thank you for your comment. Hopefully next time it will just take a few minutes :)

This was so helpful!! I have used this multiple times

Useful and helpful tutorial. Big thanks!

I love it your video. Simple and clear to follow it.

Amazing Leila. Very Helpful and I will use it at my work for Quarterly Summery.

@LeilaGharani

6 жыл бұрын

Great! You're very welcome John.

Thank you so much. The VDO is very useful I actually utilize it for presentation.

@LeilaGharani

6 жыл бұрын

That’s great. I’m happy to hear that.

thanks so much for this - exactly what I needed and explained so clearly!

@LeilaGharani

4 жыл бұрын

Glad it was helpful!

I think I am in love - brilliant video.

Really excellent! Saved my bacon on a deadline! You are very smart with Excel, Leila!

@LeilaGharani

3 жыл бұрын

Glad it was helpful!

This is way too awesome. Thanks Leila. Appreciate it.

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

@LeilaGharani

5 жыл бұрын

It's great you are developing new skills! I'm really glad I can contribute a little to that.

Thank you.. i was looking for this solution so much !!

what an awesome video as always thank you so much and i'm sorry i watched it late because in so busy in work.

@LeilaGharani

6 жыл бұрын

Thank you Ismail for your comment. Glad you like it! Of course work is priority :)

Thanks for making this kind of videos, I watch many videos, it really helped me a lot.. thank u, love your channel and subscribed

@LeilaGharani

3 жыл бұрын

Thanks for subbing!

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.

Ah. MAY. Zing. Fantastic solution to this problem which has been plaguing me all morning!!

@LeilaGharani

Жыл бұрын

Happy to help :)

Great Video. Easy instructions to follow. thsnks

Great demonstration .. Really helped me a lot ...

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.

@LeilaGharani

6 жыл бұрын

Thank you! You have a great KZread channel! Keep it up. Looking forward to the BI tutorials :)

@AweshBhornya-ExcelforNewbies

6 жыл бұрын

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.

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.

highly useful thank you to share your knowledge with others

Great chart and as always great explanation

@LeilaGharani

6 жыл бұрын

Thank you Vida.

You are a saviour!! Thank you so much!!

This is one's good. Thanks Leila

i need this, thank you so much

You genius 🤓 I needed it badly today

Thank you so much!!! I wrecked my brain to figure out this graph for my boss.

@LeilaGharani

Жыл бұрын

Glad it helped!

Thank you so much for your tutorial.

OMG thank you! This saved me such a headache.

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.

Thanks Leila for this video & information Is there a way to also have 3 number sets of data stacking along with clustered visibility ?

U are so helpful I can't thank you enough. 👍

@LeilaGharani

4 жыл бұрын

You're very welcome Hernan!

Hi Leila, could you show us how to overlay 2 radial bar charts- it would be very helpful for me at work🙏

Thank you!!

Thank you so much, very helpful

@LeilaGharani

5 жыл бұрын

You're very welcome Stuart.

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.

Awesome Leila! This is the solution I am looking for. 5:57 "Why did it do that?", so cute

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.

I love you! thanks for sharing!

Thank you for the video!!

Thank you so muchhhhhh!!!!! You are GREAT!!!!!

@LeilaGharani

6 жыл бұрын

You're very welcome :)

Great solution. Thanks Leila :-)

@LeilaGharani

6 жыл бұрын

Glad you like it Alex :)

Outstanding!!

This was exactly what I needed 🤩

@LeilaGharani

6 ай бұрын

Happy to hear that :)

Thank you so much.

like this .. I've learned many things from this video. Thanks v much

@LeilaGharani

3 жыл бұрын

Glad to hear that!

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.

@LeilaGharani

6 жыл бұрын

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

At this point, I'm just watching these because they're so satisfying.

Amazing! Thank you!

@LeilaGharani

2 жыл бұрын

Glad you liked it!

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

Thanks mam for sharing such nice and helpful videos....

@LeilaGharani

6 жыл бұрын

You're very welcome Ubaid! Thank you for your support and comment :)

@UbaidUllah-nj5et

6 жыл бұрын

You are very welcome mam...but tbh thank you for your support and help...

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

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?

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

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?

thanks for this.

thanks a lot, it helps me

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.

@LeilaGharani

6 жыл бұрын

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.

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?

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

very nice information ... but how to put standard error or deviation in this type graph

Your are a genius!

@LeilaGharani

4 жыл бұрын

😘

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.

@LeilaGharani

5 жыл бұрын

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?

Nice Trick ...

@LeilaGharani

6 жыл бұрын

Glad you like it Sukhomoy.

Hi Leila, Thanks is helpful. Also i am looing for stacked waterfall chart. Can you please share the same. Thanks once again

Interesting, could you please make a tutorial for the same with Power BI?

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

@LeilaGharani

6 жыл бұрын

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.

@BGChicks

6 жыл бұрын

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!

Hello. How can I add a percentage line? I am finding it hard to do since it has already a secondary axis. Thank you

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

@LeilaGharani

6 жыл бұрын

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

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

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

@LeilaGharani

6 жыл бұрын

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

@barttitulaerexcelbart9400

6 жыл бұрын

Leila Gharani : take your time. The longer you wait, the better the result haha...

could you explain how to create a stacked and non-stacked clustered chart. Thanks!

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!

Do you have any video on how to bring the series names inside the bars in a clustered bar graph?

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. Thanks for the video. It was very useful...! I have a question with regards of the Stacked Column chart. I already set the colors for my different data. The issue is when I delete one of the group values because I don't need it anymore, the chart automatically change all the colors and does not keep the original ones as I structured them at the beginning. The problem with this is that I need to dispose that old information and add new data to show on the chart. Is there a possibility to block the colors on the pivot chart so the ones that remains, keep their original colors? Thanks for your response! Have a nice day.

@LeilaGharani

5 жыл бұрын

Are you using you colors based on a theme? For the colors to remain the same, if another series is removed, it's best if you fix the color directly on the chart and not rely on the theme....

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

Very useful. Did not know if you kept your cursor active on the chart then added a text box it automatically becomes part of the chart without having to group it. I always use to group it...not anymore :)

@LeilaGharani

6 жыл бұрын

I also didn't know it for the longest time. I think I discovered it by accident :)

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 ?

perfect