If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
.position
I am trying to use the DataLabel.Position contruct to change the position of
a data label based on which series of chart data that it represents. Using a statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a macro. When I try to use the same code within a vB function I get an error on the statement line. Any suggestions would be appreciated. |
#2
|
|||
|
|||
Just guessing, but I suspect you didn't set the parent's .HasDataLabel
= True before you tried to set the property. This certainly applies to setting properties of axes, so I'd be surprised if it didn't apply to DataLabels too. Robert Smith |
#3
|
|||
|
|||
chazman,
Generally speaking, macros are used to perform some type of action with objects while functions are used to return value. If included in a function, a snippet of code that manipulates objects (like the data label positioning code) will return an error because it's attempting to change something in the worksheet. ---- Regards, John Mansfield http://www.pdbook.com "chazman" wrote: I am trying to use the DataLabel.Position contruct to change the position of a data label based on which series of chart data that it represents. Using a statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a macro. When I try to use the same code within a vB function I get an error on the statement line. Any suggestions would be appreciated. |
#4
|
|||
|
|||
What error?
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use the DataLabel.Position contruct to change the position of a data label based on which series of chart data that it represents. Using a statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a macro. When I try to use the same code within a vB function I get an error on the statement line. Any suggestions would be appreciated. |
#5
|
|||
|
|||
If you're not setting a reference to Excel in your VB project, VB will
not know the value of the constant xlLabelPositionAbove, which is 0. My object browser does not find "xlDataLabelAbove", and recording a macro uses "xlLabelPositionAbove". - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ chazman wrote: I am trying to use the DataLabel.Position contruct to change the position of a data label based on which series of chart data that it represents. Using a statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a macro. When I try to use the same code within a vB function I get an error on the statement line. Any suggestions would be appreciated. |
Thread Tools | |
Display Modes | |
|
|