Orientation Property

Orientation Property

         Example         Applies To

Returns or sets the object's orientation, as shown in the following table. Read/write Long.

Object Orientation
ChartObject, ChartObjects Embedded chart placement. Can be one of the following XlPlacement constants: xlFreeFloating, xlMove, or xlMoveAndSize.
PageSetup Portrait or landscape printing mode. Can be either of the following XlPageOrientation constants: xlLandscape or xlPortrait.
PivotField, CubeFields The location of the field in the specified PivotTable report. Can be one of the following XlPivotFieldOrientation constants: xlColumnField, xlDataField, xlHidden, xlPageField, or xlRowField.
AxisTitle, ChartTitle, DataLabel, DisplayUnitLabel, Range, Style, TextFrame The text orientation. Can be an integer value from  – 90 to 90 degrees or one of the following XlOrientation constants: xlDownward, xlHorizontal, xlUpward, or xlVertical.
TickLabels The text orientation. Can be an integer value from  – 90 to 90 degrees or one of the following XlTickLabelOrientation constants: xlTickLabelOrientationAutomatic, xlTickLabelOrientationDownward, xlTickLabelOrientationHorizontal, xlTickLabelOrientationUpward, or xlTickLabelOrientationVertical.

Remarks

For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report.