ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2007: bug when changing labels (https://www.excelbanter.com/excel-programming/378157-2007-bug-when-changing-labels.html)

mrt

2007: bug when changing labels
 
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


Jon Peltier

bug when changing labels
 
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




mrt

bug when changing labels
 
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





Jon Peltier

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








All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com