Skip to main content

XlCondFmtRuleDataBar.AxisPosition Property

Gets or sets the axis position in a cell.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public XlCondFmtAxisPosition AxisPosition { get; set; }

Property Value

Type Description
XlCondFmtAxisPosition

One of the XlCondFmtAxisPosition enumeration values.

Available values:

Name Description
Automatic

Displays the axis at a variable position based on negative and positive values.

Midpoint

Displays the axis at the midpoint of the cell.

None

No axis is displayed. Negative and positive bars are displayed in the same direction.

Remarks

The data bar axis is displayed only in case there are negative values in the cell range to which the data bar conditional formatting rule is applied. The default value for the AxisPosition is Automatic when the axis is displayed at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range.

See Also