Thread: Auto placement of bar chart labels

Hi
I have a bar chart in Excel and I need to display the data value as a label above the top of the bar. The data labels by default seem to get stuck right on the middle of the bar, making it hard to read - I can manually move the labels so they are above the top of the bar as required, but if the data changes and the bar grows/shrinks, then the label stays where it is.

Is it possible to make the labels so that they automitcally sit just above the top of the bar, and automatically move up/down if the bar value changes?

Thanks!