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" <(E-Mail Removed)> wrote in message
news:6B1E03EA-9D6A-43D4-92B0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:6B1E03EA-9D6A-43D4-92B0-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:FFB2510D-2787-4961-A039-(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:6B1E03EA-9D6A-43D4-92B0-(E-Mail Removed)...
>> > 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
>> >
>>
>>
>>