DataBarConditionalFormatting.AxisPosition Property

Gets or sets the axis position in a cell.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

ConditionalFormattingDataBarAxisPosition AxisPosition { get; set; }

VB.NET

Property AxisPosition As ConditionalFormattingDataBarAxisPosition

Property Value

Type	Description
ConditionalFormattingDataBarAxisPosition	One of the ConditionalFormattingDataBarAxisPosition enumeration values.

Available values:

Name	Description
None	No axis is displayed. Negative and positive bars are displayed in the same direction.
Automatic	Displays the axis at a variable position based on negative and positive values.
Middle	Displays the axis at the midpoint of the cell.

Remarks

The axis of data bars is displayed only when there are negative values in the range of cell to which the data bar conditional formatting rule is applied. The default value for the AxisPosition property 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.