Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing y axis labels | Charts and Charting in Excel | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
how to keep data labels in chart in 2007 from changing? | Charts and Charting in Excel | |||
Changing the inner border of bar labels? | Charts and Charting in Excel |