Position Property

  • Article

Returns or sets the position of the object.

  • ChartAxisPositionEnum

ChartAxisPositionEnum can be one of these ChartAxisPositionEnum constants.
chAxisPositionBottom
chAxisPositionCategory
chAxisPositionCircular
chAxisPositionLeft
chAxisPositionPrimary
chAxisPositionRadial
chAxisPositionRight
chAxisPositionSecondary
chAxisPositionSeries
chAxisPositionTimescale
chAxisPositionTop
chAxisPositionValue
  • Read/write ChartDataLabelPositionEnum for the ChDataLabels object.
ChartDataLabelPositionEnum can be one of these ChartDataLabelPositionEnum constants.
chLabelPositionAutomatic
chLabelPositionBottom
chLabelPositionCenter
chLabelPositionInsideBase
chLabelPositionInsideEnd
chLabelPositionLeft
chLabelPositionOutsideBase
chLabelPositionOutsideEnd
chLabelPositionRight
chLabelPositionTop
  • Read/write ChartLegendPositionEnum for the ChLegend object.
ChartLegendPositionEnum can be one of these ChartLegendPositionEnum constants.
chLegendPositionAutomatic
chLegendPositionBottom
chLegendPositionLeft
chLegendPositionRight
chLegendPositionTop
  • Read/write ChartTitlePositionEnum for the ChTitle object.
ChartTitlePositionEnum can be one of these ChartTitlePositionEnum constants.
chTitlePositionAutomatic
chTitlePositionBottom
chTitlePositionLeft
chTitlePositionRight
chTitlePositionTop

expression.Position

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Example

This example puts the legend for the specified chart to the left of the plot area.

Sub AddLegend()

   Dim chConstants

   Set chConstants = ChartSpace1.Constants

   ' Enbable the legend for the first chart in Chartspace1.
   ChartSpace1.Charts(0).HasLegend = True

   ' Set the position of the legend.
   ChartSpace1.Charts(0).Legend.Position = chConstants.chLegendPositionLeft

End Sub

Applies to | ChAxis Object | ChDataLabels Object | ChLegend Object | ChTitle Object