Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error 1004 when programming DataLabels.Position | Excel Programming | |||
Lock the chart but leave datalabels position editable | Charts and Charting in Excel | |||
Be able to edit position of datalabels in a protected chart. | Excel Programming | |||
How to assign datalabels to a scatter chart, obtaining the labels. | Excel Discussion (Misc queries) | |||
Excel Chart Datalabels | Excel Programming |