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.

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.

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.