Data label above columns??

[Kadence]

Hi,

I have some stacked column charts and I want the data labels to appear just
above each column. Is that possible?

I'm using excel 2003 version and the only options i can see for the label
positions are "inside end", "center" and "inside base" - so at the moment I'm
moving each data label manually and this is very time concuming!

Thanks in advance for any advice you offer

K

 

[Luke M]

I'm afraid it's not an option due to the confusion it would cause. If the
label is above the stack it refers to, it could be sitting on top of another
stack, thus making it unclear as to which stack it is actually referring to.

 

[Andy Pope]

Hi,

As Luke points out this is not an option due to the potential confusion over
the association of data point with data label.

Having said that it is possible to get the effect by add dummy series,
plotting them as stacked line. Then using the line series to display data
labels with the alignment set to Above. The dummy series would be based on
the same data as the columns.

Cheers
Andy