Adding % change to bar graph

Hello. I have a bar graph showing volume per year. If I would like to add a % change in each of the bars how can I do this? I tried copying in a text box with a reference to another cell but it didn't work. Help appreciated.

Hi amartino44,

You can do this by creating a stacked bar chart and changing the fill to no fill for the 2nd series that is only used for the percentage label.

Here is a step-by-step tutorial as well as a video showing you how to do this for a column chart, but the same principles apply.
How-to Put Percentage Labels on Top of a Stacked Column Chart

Here is a step-by-step tutorial as well as a video showing you how to do this for multiple %'s on a column chart, but the same principles apply.
Add Multiple Percentages Above Column Chart or Stacked Column Chart

Please let me know if this helps.

Steve=True

Thanks for that. That was helpful, but I still need to figure out how I can reference another cell in a text box. It ends up working fine, but then when I copy the chart into word or email, the text box with thte % doesn't show up.

Alex

Thanks for that. That was helpful, but I still need to figure out how I can reference another cell in a text box. It ends up working fine, but then when I copy the chart into word or email, the text box with thte % doesn't show up.

Alex

Hi amartino44,

The solutions I provided do not use text boxes but actual labels in the chart/graph.

I think they will copy over.

Have you tried the approaches in the tutorials versus a text box?

Steve=True