How To Show Percentages in Stacked Excel Charts (in addition to values)

The best!

Great ! Please, do you know how to do it in PowerBI ?

Thanks Leila, this video was very usefully to my analysis. Regards.

So helpful, thank you <3

what if i have 5 stacks and i want to show the total data label. however, one stack is too big and the other four are very small. it does not allow space to be able to add those labels

Thank you for this video! Your videos are always the first I look at for Excel tips, as I have found them to be clear and useful for many years. This has just helped me present some charts much more clearly for my MSc - much appreciated :)

Thank you

Hi Leila, thank you for the training. Is there a way to do this with a Pivot table as source?

Rather too fast at times-please slow down

Thank you very much. It's very helpful.

Leila. Great video. Is it possible to create a stacked actual versus target?

Can we see percentage on bars and a table in below with the numbers?

Take my bow

What a delicious voice!! 😍

Great. it was very help ful

Thank you so much !

I'm sorry, but this is not what the issue is: I don't want to create percentages as labels, but simply show percentages from the values in the chart. For instance, The label shows the value and below it the percentage. That's the real questions.

Thanks a lot Leila 🙏

Thank you so much this saved me!

How to put a percentage range in a 100% stacked area chart?

% ^ thanks!!! :D

Great content!

Percentages in Stacked Charts with Total Values on Top? Exactly what I need. Thank you so so much, Leila.

Leila, love your vids, thank you so much! Question, if the data has several items with very small percentages (<6%) and one item that is say >94%, how would you recommend displaying the data showing the smaller items (~8 items) and still being able to see the percentage for each smaller item? TY so much!

you mention a previous video in here and I think that is the one I am looking for, I remember using it last year when I was working on some reports but can't seem to find it, how would I find that?

Saved me tons of time! Tks, Leila!

thanks

Thanks for this video, just i want undersand how to visualize the pourcentage values in X axis, please?

thanks. u always give simple solution

Wow this is really helpful for me, thank you, solved my problem

@Leila
Thanks for this video,
saved me tons of time!!!
keep up great work

Thank you so much!

Like the persian accent, too :)

thank you so much. very helpful.

Excellent work as always Leila - helped me get out of a bind!

Thank you so much for sharing this video. I was kind of struggling to work on the multiple values in the chart. Now this video gonna help me to make my presentation to a better version 🤞 Thanks again. You are a great teacher 👍

Thank you but can please also show how to reverse the order of the numbers say i want the number value first followed by the percentage (%), example : 1,600 (74%) . Thank you.

Can we do the same with the pivot chart

Your video are excellent. I learn a lot. Could you tell me how to show the percentage of a data value in a column chart, not a stackbar. Thank you in advance.

How can I represent percentage in slicer function

Thank you for this tutorial ❤️

I am running Excel 2016 on Mac and on selecting the stacked column chart, total for me comes as a category on the horizontal axis instead of it being stacked on top like it is coming for you. How do I change it to the way it is coming up for you? Thanks!

awesome job

How do I add totals to a horizontal stacked bar chart?

Why fucking 12 minutes

Very helpful video, thanks a ton, whats the steps if I want to show the number first and percentage next?

Loved it!!

The last part of the video where you say use the Y Axis to deduce the value is a little too confusing at times so why don’t we create a VBA code and give the control to the user to se the values or values as percentages through the code. Just a thought.

Hey Leila, I'm trying to add percentage differences like you've shown in the video. However, I'm using a column chart and not a stacked chart and which has two series of data . I've tried adding a new series and then removing the colour and the column line, so the new series sits behind the column I want to show, but for some reason the new data series is not hiding behind the first series. No matter how much overlap I apply, the new series sits between the two columns. Obviously, I want to use the third series to add the % data labels. Do you have any tutorials which can help me resolve this issue? Hope you can help. Thanks.