how do I fix the data label to one data point?

[ng]

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.

 

[Andy Pope]

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

 

[Mike Middleton]

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