Hi,

It all depends on the chart type you are working with. For instance a
column chart datalabels can only be positioned using the following.
xlLabelPositionOutsideEnd
xlLabelPositionInsideEnd
xlLabelPositionCenter
xlLabelPositionInsideBase
xlLabelPositionCustom

To manually see what position are available check the Label Position
dropdown on the Alignment tab of the format dialog for datalabels.

Cheers
Andy


Michael Singmin wrote:
Hello group,

I am using Excel 2003.

For a chart with labels, I am using
.datalabels.position = 2 : Outside, 3 : Inside, 4 : Bottom
How do I implement these defined constants below (VBA Help) ?

XlDataLabelPosition can be one of these XlDataLabelPosition constants.
xlLabelPositionAbove
xlLabelPositionBestFit
xlLabelPositionCustom
xlLabelPositionInsideEnd
xlLabelPositionMixed
xlLabelPositionRight
xlLabelPositionBelow
xlLabelPositionCenter
xlLabelPositionInsideBase
xlLabelPositionLeft
xlLabelPositionOutsideEnd

If I use .DataLabels.Position = xlLabelPositionBelow
I get a run time error 1004
Curiously,
? XlLabelPostion.Right
-4152
and
? XlLabelPostion.Left
-4131

Any insights

Michael Singmin



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info