Returns or sets the position of the data label. Read/write XlDataLabelPosition.
XlDataLabelPosition can be one of these XlDataLabelPosition constants. |
xlLabelPositionBelow |
xlLabelPositionCenter |
xlLabelPositionInsideBase |
xlLabelPositionInsideEnd |
xlLabelPositionLeft |
xlLabelPositionMixed |
xlLabelPositionOutsideEnd |
xlLabelPositionRight |
xlLabelPositionAbove |
xlLabelPositionBestFit |
xlLabelPositionCustom |
expression.Position
expression Required. An expression that returns one of the above objects.
Position property as it applies to the Legend object.
Returns or sets the position of the legend on the chart. Read/write XlLegendPosition.
XlLegendPosition can be one of these XlLegendPosition constants. |
xlLegendPositionBottom |
xlLegendPositionCorner |
xlLegendPositionLeft |
xlLegendPositionRight |
xlLegendPositionTop |
expression.Position
expression Required. An expression that returns one of the above objects.
Example
This example sets the position of the legend to the top of the chart.
myChart.Legend.Position = xlLegendPositionTop