Position Property

Position property as it applies to the DataLabel and DataLabels objects.

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.

This example sets the position of the legend to the top of the chart.

myChart.Legend.Position = xlLegendPositionTop
Show: