Code Text Into Chart 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

 

[John Green]

Phil,

Attach data labels to your chart points.

If you want to use any text, it is quite tricky to do this manually. Using code you can do something like the following:

Set seSales = ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1)
seSales.HasDataLabels = True
seSales.Points(2).DataLabel.Text = "Oranges"

 

[Phil Hageman]

John, Thanks for your response. I want to leave data
labels alone - they show a plotted value, say 100, 200,
etc. I would like to somehow attach text to the line that
says "Oranges". Another line could represent "Apples" etc.

Phil

-----Original Message-----
Phil,

Attach data labels to your chart points.

If you want to use any text, it is quite tricky to do

this manually. Using code you can do something like the
following:

 

[Phil Hageman]

Thanks, John

-----Original Message-----
That's exactly what my code does.

--

John Green - Excel MVP
Sydney
Australia





.