Ability to automatically put labels on chart on top of a bar (not inside)
At the moment, ppt only gives options to put labels on bar charts inside the column (either bottom, middle or end). Would be very useful to have an automated way to put labels on top of the bar.
Also if it is a stacked bar chart, it would be great to be able to automatically add a label which would show the total amount of the bar
We currently provide the following positions for data labels on bar charts: Center, Inside End, Inside Base, Outside End. I believe what you are asking for is Outside end.
Adding a total to the bar is an interesting idea which we’ll roll into our feature considerations for a future release.
It would be useful to have an 'Outside side' option for stacked bar charts. Currently, I want to display counts/percentages of stacks bars, some stacks are too small are are covered by the data labels.
Add a total to a stacked column chart: add a column to the data range that sums the other columns. This is added as another stacked column in the chart. Change this added stacked column to a line, format its label position to Above, and format the line to No Line.
Shoot, in a clustered column or bar chart, Outside End is the default label position.
Echo Swinford commented
Does outside end not work for you? That lets you put labels at the end of the bar or column.