View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default bug when changing labels

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