Just another problem: when you applylabels to a series, then set all values
but one to "" (empty string), except one to "Mylabel", you will see that only
the change for the "Mylabel" has been taken into account.

Regards,

MrT

Details? Manually or in code?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MrT" wrote in message
...
Just another problem: when you applylabels to a series, then set all
values
but one to "" (empty string), except one to "Mylabel", you will see that
only
the change for the "Mylabel" has been taken into account.

Regards,

MrT

Details? Manually or in code?

With MySeries
.ApplyDataLabels
For i = 1 To .Points.Count
.Points(i).DataLabel.Text = iLabels(i)
Next i
End With

if iLabels is "a","","","","" it doesn't change anything but the first one
if iLabels is "a"," "," "," "," " it does the job for all

_______


"MrT" wrote in message
...
Just another problem: when you applylabels to a series, then set all
values
but one to "" (empty string), except one to "Mylabel", you will see that
only
the change for the "Mylabel" has been taken into account.

Regards,

MrT

The labels all were changed for me, even the blanks. Sometimes you don't see
the changes until you select the chart (and force a redraw, perhaps?).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MrT" wrote in message
...
Details? Manually or in code?

With MySeries
.ApplyDataLabels
For i = 1 To .Points.Count
.Points(i).DataLabel.Text = iLabels(i)
Next i
End With

if iLabels is "a","","","","" it doesn't change anything but the first one
if iLabels is "a"," "," "," "," " it does the job for all

_______


"MrT" wrote in message
...
Just another problem: when you applylabels to a series, then set all
values
but one to "" (empty string), except one to "Mylabel", you will see
that
only
the change for the "Mylabel" has been taken into account.

Regards,

MrT