View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default how do I fix the data label to one data point?

ng -

And is it also possible to draw lines to the axes from one data point I
chose? <


One approach is to use error bars.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"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.