excel 2007 chart data label - several lines put highest number ove

[Sue]

I have a chart with 3 lines with a data label. Is there any way to
automatically put the Highest number to be over the line and the other line
data label?

 

[Andy Pope]

Hi,

You could use another series to display data labels based on a condition.
See Jon's example which does it for points, but the same principle can
apply to data labels.
http://peltiertech.com/Excel/Charts/PointAtPoints.html

And this labels the last point but again can be adapted.
http://www.andypope.info/ngs/ng17.htm

Cheers
Andy