Text attached to data lines

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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
 
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
 
Back
Top