.position

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
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/
_______
 
Back
Top