Stacked charts and adding % of total

I have created a stacked bar chart and want it to show each stack as a percent of total. Currently it shows the numerical value as the data lablel. I would like it to show the numerical total at the top of the bar with the % of total each section the bar represents, but don't want to add a bunch of text boxes to accomplish this. Is this possible? Thanks!

Hi Matthewm,

Welcome to the forums.

Yes this is possible.

Here are a few step-by-step tutorials with videos to show you how to do it.

How-to Put Percentage Labels on Top of a Stacked Column Chart

Add Multiple Percentages Above Column Chart or Stacked Column Chart

Please let me know if this helps.

Steve=True

Thanks for the tips. They were very helpful.

That is wonderful.

So glad it help you.

Thanks for the feedback.

Steve=True