.position

[Guest]

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.

 

[ubik]

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

 

[Guest]

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.

 

[Tushar Mehta]

What error?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

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/
_______