Orientation Element (Microsoft Excel)

Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis.

For an axis scale, specifies whether the direction of the axis is from minimum to maximum or maximum to minimum. For an error bar, specifies whether this error bar is horizontal or vertical.

Contained In

CubeField, ErrorBars, PivotField, PTLineItems, Scaling

Remarks

For a cube field, this element contains one of the following string constants specifying the axis the field is on or whether the field is hidden: Column, Data, Hidden, Page, or Row. If this element is not specified, the default value is Hidden.

For an error bar, this element contains one of the following string constants specifying the direction: X for horizontal or Y for vertical.

For a PivotTable field, this element contains one of the following string constants specifying the field orientation: Column, Data, Hidden, Page, or Row. If this element is not specified, the default orientation is Hidden.

For a PivotTable field on a PivotList component, this element contains one of the following string constants specifying the field orientation: Column, Data, Page, or Row. If this element is not specified, the field is not on an axis.

For a PTLineItems element, the Orientation element contains one of the following string constants: Row or Column. If the Orientation element is not specified, the properties in the PTLineItems element apply to a row.

For an axis scale, this element contains one of the following string constants.

Constant Description

MinMax For horizontal axes, the values are arranged least to greatest from left to right. For vertical axes, the values are arranged least to greatest from bottom to top. For polar axes, the values are arranged least to greatest from the center to the outer circumference.

MaxMin For horizontal axes, the values are arranged least to greatest from right to left. For vertical axes, the values are arranged least to greatest from top to bottom. For polar axes, the values are arranged least to greatest from the outer circumference to the center.

Examples

See the examples in the PivotTable and WebChart element topics.

Constant	Description
MinMax	For horizontal axes, the values are arranged least to greatest from left to right. For vertical axes, the values are arranged least to greatest from bottom to top. For polar axes, the values are arranged least to greatest from the center to the outer circumference.
MaxMin	For horizontal axes, the values are arranged least to greatest from right to left. For vertical axes, the values are arranged least to greatest from top to bottom. For polar axes, the values are arranged least to greatest from the outer circumference to the center.