PivotFieldSet object: Returns a PivotFieldSetOrientationEnum constant that represents the field set orientation. A field set can be located on both the summary axis and the column, row, or filter axis at the same time. Read-only.
PivotFieldSetOrientationEnum can be one of these PivotFieldSetOrientationEnum constants. |
plOrientationColumnAxis |
plOrientationDataAxis |
plOrientationFilterAxis |
plOrientationNone |
plOrientationPageAxis |
plOrientationRowAxis |
ChAxis object: Returns or sets a Long that represents the orientation of the labels on the specified axis. Can be a ChartLabelOrientationEnum constant. Read/write.
ChartLabelOrientationEnum can be one of these ChartLabelOrientationEnum constants. |
chLabelOrientationAutomatic |
chLabelOrientationDownward |
chLabelOrientationHorizontal |
chLabelOrientationUpward |
ChScaling object: Returns or sets a ChartScaleOrientationEnum constant that represents the scaling orientation. Changing the value of this property flips the chart. Read/write.
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.
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