Skip to main content
Row

DataBarConditionalFormatting.AxisPosition Property

Gets or sets the axis position in a cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

ConditionalFormattingDataBarAxisPosition AxisPosition { get; set; }

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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the AxisPosition property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also