Showing percentages above bars on Excel column graph

Question

I have a graph that is pulling data from a PivotTable, so I get a distribution of counts (how many in category A, how many in B, how many in C, etc)

But above each bar I also want to show a percentage of the whole. So for example I might be able to say "This bar for Category A shows we clearly have 2000 of it, but see the number on top of the bar, it's only 15% of the total"

Does this make sense?

Answer 1

In Excel for Mac 2016 at least,if you place the labels in any spot on the graph and are looking to move them anywhere else (in this case above the bars), select:

Chart Design->Add Chart Element->Data Labels -> More Data Label Options

then you can grab each individual label and pull it where you would like it.