Thread: excel 2007 chart data label - several lines put highest number ove
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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
Reply With QuoteReply With Quote