How to Add Total Values to Stacked Chart in Excel

[@LeilaGharani]

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

[@siraatmedia8348]

To do this in a Pivot Tables, a work-around is to: 1. Make a calculated Field which is sums up the individual columns - This is your "Total" Column. Add that to the Pivot Table 2. Follow from 2:15, but instead of changing it to a Scatter, change it to a line chart 3. Add Data Labels as usual 4. Make Lines (and markers) transparent or white Hope this helps!

[@jean-pierrekuntz6518]

Can you give more information ? I can not add a calculated field in my powerpivot, the option ie greyed. I can not modify the source as it comes from a database. Is there a way to use the automatic grand total from the power pivot ?

[@denis7369]

@@jean-pierrekuntz6518 same issue here

[@Lessareve]

I have been struggling with this for work (we use excel only very occasionnally), thank you so much for the easy and straightforward tutorial! made my day !

[@Farisnb]

whenever I get lost or I look for something in Excel, I come to your page and I find it. Thank you for creating this amazing library Leila

[@sharknado523]

Leila, as always your clear and concise explanations have helped me get something done in less time! Love your tutorials. Thank you so much.

[@deetee8051]

omg finally someone was able to come up a workaround, not sure why a simple feature like this being made so hard

[@jess22682]

Thank you. This helped me finish a project for work.

[@ShuttleV2]

You Rock!!! I love following your videos...thank you so much!

[@peoplelifework8518]

Thank you for your tutorials!!

[@joey325]

Thanks!

[@LeilaGharani]

Thank you!

[@bradfordnhull]

Just what I was looking for!

[@saurabh4059]

Excellent....exactly what I needed. Thanks

[@SathishKumar-cl1di]

Thank you so much clear explanation. You saved my time .

[@John-ur1jn]

Just what I was looking for in a pinch. Well explained and easy to follow. Thanks!

[@LeilaGharani]

Glad to hear that John.

[@79glastron]

wow, you really know you excel charts. thank you

[@Kielyoutube]

Thank you for this! It's 2023, MS should just add this as a checkbox rather than us having to go through all these steps 😆

[@sj6361]

Thanks Leila for a very useful lecture. Can you please tell me that how can we add Total values in a Pivot Table stacked Chart? Best Regards Shahid

[@nuanhe9563]

that will be very helpful! The grand total cannot be selected as a data series in pivot chart...

[@jamesperry3837]

Nice tutorial Leila esp with bringing in the TOTALS on a XY Scatter. Thanks.

[@LeilaGharani]

You're welcome James. Scatter plots are great for this type of chart manipulations :)

[@rizkymaryadi843]

You are savior!

[@carlarosas2715]

Very easy to follow !!!. Thanks ;)

[@jagmohansinghbhui191]

Thanks madam very nice way you are teaching

[@juliomazzarella7523]

Your presentations are excellent. Clear, to the point and very helpful. Thank you for sharing your knowledge.

[@LeilaGharani]

You're very welcome. I'm glad you find the videos useful :)

[@ivanfletcher4671]

thanks for sharing this was of good use.

[@arnelhusic953]

Great video, thank you.

[@jeru02]

This saved me today at work. Thanks Leila!

[@LeilaGharani]

Perfect! You're very welcome.

[@ludvikjerabek]

Thank you!

[@monikakalinska5646]

Brilliant!

[@excelisfun]

Total-rific Trick!!! Love it : )

[@LeilaGharani]

Total-rific :) love that!

[@excelisfun]

: )

[@rienthongw]

Thank you, Leila. It's clearly understanding.

[@LeilaGharani]

You're very welcome :)

[@kodidiba8718]

I love your videos... good luck 😊😊😊

[@LeilaGharani]

Thank you! You too!

[@kalyanthammineni4423]

Thank you Leila. I got exactly what I needed.

[@Ar-kh5ph]

So helpful, thanks

[@mohamedmami2480]

Thanks a lot Leila... It's really useful & helpful video.

[@LeilaGharani]

You're welcome Mohamed.

[@drash4489]

Thank you for great video . How do you create Variable width column charts and histograms in Excel. I m trying to create a cut (cost utilization diagram )

[@robertakwasiadjei8223]

Great Presentation my dear

[@jacquesklein]

Thank you very much! Very didatic!!

[@elizabethstein369]

Thanks for the help! Saved my butt!

[@LeilaGharani]

Glad this helped :)

[@olivia_koo__]

Thank you Leila! you saved me too today!

[@LeilaGharani]

You're welcome. Happy to help out.

[@gyorgykerezsi1118]

Thank you!

[@sadeqreshtin7195]

Thank you so much!

[@Dev_Bartwal]

Very useful trick LG Thanks

[@LeilaGharani]

You're very welcome.

[@SyedVkax]

very helpful, please tell me how we can add total like this to pivot stacked charts?

[@osamasalah341]

You are brilliant!

[@LeilaGharani]

Ohhh thank you Osama - glad you like the video :)

[@rienthongw]

Thank you for sharing. It is very useful. May I ask you about how can I compare a small value in data table and which graph would be perfect.

[@patturoxxxx]

excellent video, chat GPT couldnt answer this

[@ncnc2896]

simply wowww!! thank you Leila !

[@LeilaGharani]

You're welcome NC.

[@contextmatters8243]

This video is great, as always, But This technique doesn't seem to work with pivot tables., Thoughts?

[@deepcoolclear]

Very good explanation. How do you change the height of the stacks (diff colors) containing the data series values? Sometimes for very small values excel makes the height of the cell too small to fit the data label font.

[@mchamis1]

Thanks for sharing.

[@robertakwasiadjei8223]

You are one in a million.

[@LeilaGharani]

Thank you Robert.

[@admiralmyxtar3702]

It's very sad that Excel need this much working around to do such a simple thing. Your way is very clever anyway, thanks a lot

[@FarahWahhab]

Thank you

[@sabbe14]

Leila thanks for the tip... However i've been looking for a solution to do this but on a PIVOT table chart. in the pivot I automatically get the grand total but this is not visible in the chart. Any way to do this? many thanks !

[@caycoo]

I came here looking for the same thing! I was just about to ask the same question when I saw no-one has been able to answer yours from 6 months ago... 😥

[@dvesfvhssss]

Thank you very very much I have master you chart.

[@LeilaGharani]

You're welcome Seoin.

[@smezher]

im a big fan!

[@jean-pierrekuntz6518]

Great tip, but i need mor information to to it with a pivot table.

[@vladimirjalovi7360]

Thank you.Thank you.Thank you.Thank you. :D

[@LeilaGharani]

You're very welcome Vladimir :)

[@automationguide3498]

Thank You !!

[@LeilaGharani]

You're welcome Harsha.

[@ExactProBi]

thanks for another awesome tip, could you please also tell us how to put values and % of values in each stack? I want values along with % of same values (outside each bar).....

[@LeilaGharani]

Yes, you can also add percentages - you have to add in a new series for that - or combine it with the total series. I'll make a video on that - It'll be the one after next.

[@rabihel-habta313]

you are awesome

[@Sal_A]

Keep up the charting videos....there isn't much videos on charting techniques.

[@LeilaGharani]

Thanks Sal. Will do :)

[@khuram2311]

Simplified explanation 🫡

[@vida1719]

Awesome!

[@LeilaGharani]

Glad you like it Vida.

[@danielfelipegonzalezramire9465]

Hi Leila, Im trying to do this, but in a Dynamic Chart and i havent achieved it yet, help me. thanks great video.

[@alpeshdoshi7827]

hi....madam how r u? thank you madam for such nice vedio..it's very helpful​

[@LeilaGharani]

Thanks Alpesh. Gald you find it helpful.

[@alexrosen8762]

Beautiful! Thanks Leila :-)

[@LeilaGharani]

You're welcome Alex.

[@ryanbacusmo7182]

Hi Leila, i tried to follow your instructions but when add the total value and change the series chart type from stacked column to scatter I dont see the scatter option in the drop down.

[@julianalimrn9075]

How is this done on a Pivot Chart that is dynamic with slicers? I've seen a really complicated solution, but I'm wondering if there is a simpler solution.

[@hosseinhosseinpoor4845]

thanks

[@nooshkafg]

Hi Leila, Thanks so much for these great tutorials. I have one question. I somehow can't find the "change series chart type" on my Excel (2018). When I right click on the chart, it just comes as select chart type and does not give an option to customise or to select chart series. Is there a way I can add this option? Thanks!

[@LeilaGharani]

You need to click on the series (bar, column, etc.) itself. Not just anywhere in the chart area. If you click on the data series you will get it as an option.

[@nooshkafg]

@@LeilaGharani Thanks for the reply Leila. Much appreciated. It somehow does not work still. It gives select chart type no matter where I click on the chart (bars,column and so on). I guess I might need to update.

[@indryfitriani]

Dear Leila, how if the table is a pivot table... thank u

[@Keepitsimplestt]

Can you make some lines to connect 3 columns to see trend on each area and year?

[@LeilaGharani]

Yes - watch this video: kzbin.info/www/bejne/rWjPfp6EpM-WZqc

[@ixanification]

Terimakasih

[@juanvicencio2390]

Hi Leila, is there a way to create a sort of stack-chart where you can see how much of one amount belongs to the total amount? For example. If I have a revenue of 10,000 and COGS of 6,000 I will have an operating profit of 4,000. Could I graph the 4,000 over of the 10,000 so I can see how much of the total revenue is operating profit? I notice when you use stack bars the amounts are added, but what I want to see is part of the total. I guess I could do it with columns but it looks nicer as it it would be stacked thank you!

[@kaaa3485]

I have the total on the side but I could not add it. What if the total is on the side instead the bottom? Thank you so much

[@Hoparistic]

Thank you so much, the instructions in the class I'm in are totally incompetent

[@001Elpato]

Hi Leila, pls how do I add the grand total for this stacked columns chart if I have the chart build out of pivot table?

[@LeilaGharani]

You are quite restricted with Pivot Charts. Best is to create a pivot table and use the GetPivotData function to reference the values of the pivot in a dynamic way and then create a normal chart like I show in this video - this way your data is driven by the pivot, but you are using a normal chart.

[@001Elpato]

@@LeilaGharani thank you

[@rislamov]

Very cool trick. But how to add such labels if you use pivotchart?

[@LeilaGharani]

For such cases, when my data is in pivottables, I use the getpivotdata function to extract them in a dynamic way from the pivot table and base my chart on this "data preparation" table - this way you can use the "usual" chart techniques and are not limited by the PivotChart functionalities.

[@QueLastima]

@@LeilaGharani When you make a chart based on a pivot table, it's 'automatically' a pivot chart. You're saying copy the data to a non-pivot table and build the chart? That's a bit clunky? If you use GetPivotData... You need a second table, pointed at the Pivot table? That seems a bit odd, to make a second table exactly like the pivot table with the pivot table data in it...

[@raghav8888]

I have a pivot table and plotted as stacked bar chart. How do I show the total for each bar?

[@MaewNoy]

Can I change color font for Year 2014 only?

[@deefees]

This doesn't seem to be compatible while adding a 'graph data tabel'? I wanted to show YTD numbers, TODOo-numbers in the graph, and underneath in a table I want to show those two but also add a total.

[@enricoforgac8131]

How Can I sort the values inside of the columns?

[@meliheser01]

is there a way to do it in 3d stacked column

[@loreto1977]

I found the idea great but I'm facing an issue here. I have in my chart 3 series as stacked column (Primary axis, $ value), 1 series as clustered (secondary axis, %) and one series a line with markers (Primary axes, $ value). When I add the total (Primary, $ value) and change it to scatter the data table I have under my chart disappears. Any idea why?Thanks, you're great!!!

[@LeilaGharani]

The chart becomes too complex to show the data table. What you can do here is put the data table in Excel cells right below the chart and position the chart above the table.

[@AliRaza-it8wc]

Hi i want to make dashboard for different routes using date and routes filter. But I am unsure how to do it. Can you help me?

[@johnoyao]

I can't seem to have the XY Scatter option. Maybe my version of Excel?

[@johnoyao]

Figured it out; it doesn't work on Pivot Table to Charts :(

[@saradebbar6423]

can excel draw graphs out of total values without the need of entering data and counting parts?

[@LeilaGharani]

Currently for stacked charts, you have to use this workaround....

[@amitjain5432]

Hello mam, how can we add total values without adding Total in source data, I tried using power pivot charts but getting issue with Total Values, pls help!

[@mohammadkalandar1440]

I want highest value to be in top and lowest in down, is it possible

[@MN-iq6hy]

How to do the same with Bar Charts. Horizontal bars.. ?!

[@venkateshsammit2835]

in my excel Add,Edit all are hide the option how to enable that options

[@moajulius]

How to make it with stacked bar???

[@LeilaGharani]

Similar approach, just a little bit trickier. I'll see to upload a video on this one soon.

[@donglingli9320]

How to delete total at last step

[@rccowboys]

Only problem here is that can no longer show data tables at the bottom.... ??

[@rush2004]

[@cogama7846]

Thank you!

[@andreyb.decarvalho6026]

Thank you!!!

[@wesleyharper3253]

Thanks!

[@arturo2599]

Thank you!!!