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

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?
--
Sue

excel 2007 chart data label - several lines put highest numberove
 

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

Sue wrote:
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, Microsoft MVP - Excel
http://www.andypope.info