XlCondFmtRuleDataBar.AxisPosition Property
Gets or sets the axis position in a cell.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.2.Core.dll
Declaration
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.