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 how do I fix the data label to one data point?

Hi,

You need to use another series to handle displaying of specific data labels.
This include a Min/Max example.
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ng" wrote in message
...
I have to show on my chart some high and low points with the help of data
labels. So I set up some data labels on my chart. however my chart gets
each
day one new point and as the line of my chart moves the data labels which
I
set up moves to the next day. How can I fix it to the initial data point
which I chose (which is a high or low point)? And is it also possible to
draw
lines to the axes from one data point I chose? Because chart is a small
one
it is difficult to notice to which point the label is connected. I use
Excel
2003. Is it easier on Excel 2007? Thanks a lot.