Text attached to data lines

[Phil Hageman]

I have 39 charts in a workbook, where data value changes
cause movement of the lines on the charts. I use text
boxes to identify some of the data lines on the charts.
But as data values change, the text boxes stay in place
while the lines move - requiring manual repositioning of
the text box. This is out of control. How can I attach
text to a data line (coding?) such that it moves with the
line?

Thanks, Phil

 

[Jon Peltier]

Phil -

On this page I show how to label series and points in your chart, and
include a small utility that labels the last point in the series with
the series name. Hack around with the code to make it do what you want.

- Jon

 

[Debra Dalgleish]

Did you mean this page?

http://www.geocities.com/jonpeltier/Excel/Charts/LabelLastPoint.html