[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[_2_]]

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"


--

John Green - Excel MVP
Sydney
Australia


"Phil Hageman" wrote in message ...
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 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:

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


--

John Green - Excel MVP
Sydney
Australia


"Phil Hageman" wrote in message
...
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 Hageman]

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

--

John Green - Excel MVP
Sydney
Australia


"Phil Hageman" wrote in message
...
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:

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


--

John Green - Excel MVP
Sydney
Australia


"Phil Hageman" wrote in message
...
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



.



.