Orientation Property

  • Article

PivotFieldSetOrientationEnum

PivotFieldSetOrientationEnum can be one of these PivotFieldSetOrientationEnum constants.
plOrientationColumnAxis
plOrientationDataAxis
plOrientationFilterAxis
plOrientationNone
plOrientationPageAxis
plOrientationRowAxis

ChartLabelOrientationEnum

ChartLabelOrientationEnum can be one of these ChartLabelOrientationEnum constants.
chLabelOrientationAutomatic
chLabelOrientationDownward
chLabelOrientationHorizontal
chLabelOrientationUpward

ChartScaleOrientationEnum

ChartScaleOrientationEnum can be one of these ChartScaleOrientationEnum constants.
chScaleOrientationMaxMin
chScaleOrientationMinMax

expression.Orientation

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

Example

This example sets the scaling orientation for the specified axis.

Sub SetAxisOrientation()

   Dim chConstants

   Set chConstants = ChartSpace1.Constants

   ChartSpace1.Charts(0).Axes(1).Scaling.Orientation = chConstants.chScaleOrientationMaxMin

End Sub

Applies to | ChAxis Object | ChScaling Object | PivotFieldSet Object