Grab the file I used in the video from here 👉 pages.xelplus.com/stacked-chart-totals-file

At first I just downloaded your workbooks and use them as templates. Then I realized it's best to learn and do things myself. Now I create charts from scratch, step by step, beginning to end, using your instructions. Thank you Leila, I know you have to put in a lot of effort making these videos. You're my Chart Savior.

Awesome as Always

Thank you so much, Leila. Dynamic chart is great. I love your VDO, it brings my chart to another level.

@LeilaGharani

6 жыл бұрын

You're very welcome. I see, you are interested in Charts too - it's one of my favorite topics :) I'm glad to hear your reports are improving - thank you for your comment & support.

Thanks a lot for the awesome videos, Leila. They're incredibly useful. I'm learning a lot from you. Just a shout out for the Mac users. I've found it impossible to add two scatter plot series to the same chart and it took me a long time to figure out an alternative way of achieving the same results (unsurprisingly, Excel for Mac seems to be a lot less user-friendly, IMHO). It seems that a slightly different method is required and this is the only one I've found to make it work: 1- Create a chart including the main data series and the total series as stacked columns first 2- Select the total series and change it to line chart type 3- Add the legend series (use the same values for X and Y as shown in the video). It should appear as a line chart. Change it to scatter plot and attribute it to the primary axis if it's gone to the secondary. Make all the other adjusts as shown by Leila in the video (add labels, make total series and legend series invisible, etc.). More advanced Mac users may have found a more direct approach than mine. Please, Mac users, keep sharing your ideas when Excel for Mac requires a different approach. I find it a lot more difficult to navigate, to be honest! And thank you again for the great videos, Leila! I will certainly do one of your courses in the future.

Amazing, thank you sooo much. I have improved a lot in presenting charts.

Thanks a lot Leila, your lectures have enhanced the efficiency of my work. God bless you

@LeilaGharani

7 жыл бұрын

Very happy to hear that Robert.

Excellent!! Thank you!

This is bringing my charts to another level ! Thank you for the tips, keep up the good work !

@LeilaGharani

7 жыл бұрын

Great to hear! You're welcome.

That is an awesome tip!!! Thanks : )

@LeilaGharani

7 жыл бұрын

You're welcome Mike. Excel charts are a lot of fun to work with. They remind me of lego blocks....or maybe it's because of the thumbnail image :)

@excelisfun

7 жыл бұрын

Yes, I agree about the Legos... Excel is fun like Legos, videos games, math and many more fun things!

@LeilaGharani

7 жыл бұрын

Very true :)

Really Enjoyed it thanks

As always you have the best tips presented in such an easy, fun way to learn them. Kudos! I have learnt so many new ways to present data in a more dynamic and impressive way. Keep up the good work.

@LeilaGharani

7 жыл бұрын

Thanks Sher! Happy to hear that.

Leila never thought about it like that... Brilliant!

Really loving the videos. Thank you so much.

@LeilaGharani

6 жыл бұрын

Glad to hear that Kevin. You're very welcome :)

Thanks for the share.

Amazing 🤩

Fabulous. Reminds me of some of the techniques that you showed us in your Udemy Chart course! Thank you for playing my music in the background. I'm really touched by that!

@LeilaGharani

7 жыл бұрын

You're welcome Michael. It's a great melody - thank you for sharing it with me :)

thanks you are only one who teach about visuable chart.

@LeilaGharani

7 жыл бұрын

You're welcome Seoin. I'll make sure to add in more tips & tricks :)

Thanks a lot Leila. Very helpful.

@LeilaGharani

7 жыл бұрын

You're welcome Hassan.

Excellent and very helpful. thanks!!

@LeilaGharani

7 жыл бұрын

You're welcome Zaha.

Excellent video and smart tricks. Thanks

@LeilaGharani

7 жыл бұрын

You're very welcome Lotfy.

great video i have learnt a lot from your videos keep sharing the good stuff

@LeilaGharani

7 жыл бұрын

You're welcome Imran.

thanks

Awsome leila...that is a big trick

@LeilaGharani

7 жыл бұрын

Glad you like it Mohamed.

Dear ma'am I regular attender to your video .everything is good and wonderful Thanks a lot.in the next coming days I will demand new video for my use

Thanks for the video . i have a question on how to highlight the max value in different colour using pivot chart.

The best! Beauty and Brain @ its finest! :-)

@LeilaGharani

6 жыл бұрын

This made me laugh! Glad you like it.

@punchbuddies220

6 жыл бұрын

made u laugh? how so?

@LeilaGharani

6 жыл бұрын

In a nice type of way.... I don't associate myself with either the beauty or the brain :)

Good stuff. More charting techniques and tricks.

@LeilaGharani

7 жыл бұрын

Thanks Sal. Charts are also my favorite - will for sure add in more. Anything in particular you're looking for?

@Sal_A

7 жыл бұрын

You're welcome. Looking for how to create vertical and horizontal thermometer charts, bullet charts etc. Have a drop down list to show different charts.....a scroll bar that controls the chart values.....finding the right colors for a chart? When to use them?

@LeilaGharani

7 жыл бұрын

That's a good list. Thanks Sal. A lot of these are part of my online charts course on Udemy but I'll make sure to add some to KZread as well :)

Very good explanation. Sometimes for very small values excel makes the height of the stack too small to fit the data label font. Is there a way to change the stack size (height) ?

Dear Leila, thank you for the great channel. I need you to help about how can I have countries flags in my chart

A nice video

@LeilaGharani

6 жыл бұрын

Thank you!

@Shabbir2749

6 жыл бұрын

Leila Gharani mam please make a video how to insert Standard error bar in stack bar

Hi Leila, this all is not possible if we create graph from pivot table, is that right? Thank you in advance

great video Leila as always. 2x quick questions please. 1. If I have only 2x stacked column charts, how to I move them closer to each other please as the space between them make the chart too big and space wasting? 2. Also, can I do a stacked bar chart with one of the elements a line chart with no line but just a line marker please? Thanks

Hi, I have a larger data set that requires a pivot table and chart. Can this be done with a pivot table and resulting chart? Thank you.

Hi Leila, sorry to reach out to you, but I can't find a solution to a problem I have with data labels in my charts. I have two header rows, the first with an abbreviated category and the second row contains the category description. The rows below the headers show how many occurrences of each category there are for each location (The header column) I want my data labels to show the number of occurrences and the abbreviated code from the first header row. I still want to see the full description as the legend from the 2nd row. So as an example, I have a location called "Depot", with 3 incidents under the header "Staff Injury" (The abbreviated code above Staff Injury is "H"), so I want the data label to show H-3 and the legend to show the longer description of "Staff Injury" Does this make sense? Again, really sorry to ask you, but I have searched google with no luck. Thank you. Darren.

Nice video Leila, is it possible to put the legend in the right side. Thank you in advance

@andrewchiles

4 жыл бұрын

I just figured it out... on the x axis of the data label instead of adding +1, subtract -2 or whatever to get it to where you need it

@rubiedelacruz5353

4 жыл бұрын

@@andrewchiles Thank you :)

If one hides the data labels columns or groups them together and closes the grouping the labels disappear. Upon expanding the group or unhiding the data label column, the labels reappears in the chart. How can one hide the data label columns (by grouping or hiding) while the new label name remains displayed in the chart?

Dear Leila, I do not get the same results as in your example. At least with regard to the x y scatter graph. As soon as I select Change Chart Type for the x y scatter the x-axis values dramatically change. For example, the x-axis with three months of 2022 automatically starts from 1905 when the reference year should be 2022 for the minimum and maxim bounds. This change results in the x y markers appearing on the left of the chart and the rest of stacked column charge squeezed to the right.

Could you have not grouped a text box with the series of the stacked column chart so that it would become dynamic? Not sure if that would work. If I have Excel 2010, what makes a text box with a formula pointing to the labels different than method you employed?

@LeilaGharani

7 жыл бұрын

Unfortunately you can't group with the stacks. You can group with the chart object, but the size of that doesn't change. There is no major difference between the version I showed to the one you mentioned - it just takes a bit longer to click on each text box and add the formula in. The one I showed, is also dynamic so if you have a new stack added in the middle, the stack label is automatically taken over, whereas with Excel 2010 you have to manually create the formula reference.

excellent tip madam.... thanks. madam can u please make vedio for searching drop down list...

@LeilaGharani

7 жыл бұрын

You're welcome Alpesh. Not sure what you mean by searching drop down list - could you give me more detail on that?

@alpeshdoshi7827

7 жыл бұрын

Leila Gharani ok madam we make drop down list by data validation..but suppose ,in that list there are thousands item , so we have to look all list up to end to find specific name, but if we type initial letter of name so relete to that letter all name come up dynamic. hope you got my point thanks

@LeilaGharani

7 жыл бұрын

Hi Alpesh - Unfortunately there is no built in way to do this - no formulas etc, but VBA would be able to handle it....I'll add this to my list. Thanks for sharing.

@alpeshdoshi7827

7 жыл бұрын

ok...madam. waiting for next video

Thank you for these amazing technique! But i stuck at how can you add X-Y series into the chart? I tried but it's always add only one series.

@LeilaGharani

7 жыл бұрын

Yes - it only adds one series if the last series you had was a column or line chart. What you need to do after you add the one series is to change the chart type to a scatter plot - after you change to scatter plot you get the option for both x and y - you need to go back to "select data" and edit the series. You're then see the options available....

@phamhoangtien

7 жыл бұрын

Bingo! I've just did it last night! Thank you

@LeilaGharani

7 жыл бұрын

That's great Pham!

in this chart how would I do below: I want Label (Country name) in each Year's Bar +++ Below to each country name I need to show its %contribution in that particular year (Example : for 2017 Bar Labels I need are : Europe 74%, America 19%,...) Plz plz reply.

please make a video how to insert Error bar in a stacked graph..

@LeilaGharani

6 жыл бұрын

Sure - but what would use the error bars for?

@Shabbir2749

6 жыл бұрын

Leila Gharani I want to show abundance of 3 species in 5 different site..so I can show abundance of 3 species in each site mean with standard error

Hi Leila, I need a small help with graphs, can I email you my requirement please ?

Good trick but it is more confusing as I need to infer that Blue represents Europe for all the series by looking at the labels which are next to the last series only. So more guess work. First chart with the legend still feels better.

Never ever ever will I say I’m “proficient in Excel” again

@LeilaGharani

4 жыл бұрын

Haha. There's always more to learn :)

Is there anyway to doing this for a 100% stacked chart?

@LeilaGharani

6 жыл бұрын

Yes - you can use the same method. It works for 100% stacked chart as well.

@MuhammadUsman1

6 жыл бұрын

Leila Gharani I'm finding it difficult to calculate X values for 100% stacked chart, by the way I'm doing it for balance sheet chart, I'll try this method for dummy data. Hope I'll find the problem. Thanks for prompt reply. Your videos are really really and really useful. Keep up the good work.

@LeilaGharani

6 жыл бұрын

X values depend on the number of categories you have on the horizontal axis - I assume you have a 100% stacked column chart right? how many categories do you have on the x axis? You just need to add 0.5 to it. If you download this workbook from the link in the descriptions and then change the dummy values to represent a 100% stacked chart, you'll see that you don't need to make any adjustments to the logic shown. Now unless you have a 100% stacked "bar" chart and not a column chart, then it's a different story.... Glad you find the videos useful Muhammad :)

@MuhammadUsman1

6 жыл бұрын

Leila Gharani my chart is horizontal, so in my case X values are Y values in your case.

@MuhammadUsman1

6 жыл бұрын

Can I have your email ID? So that we can exchange new ideas?

Cross-referencing shall be 100% avoided in presentations and presentation-like reports.