M
Michael Singmin
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
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