DataBarAxisPosition Enumeration |
Specifies the axis position for a range of cells with conditional formatting as data bars.
Namespace: Spire.Xls.Core.Spreadsheet.ConditionalFormatting
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Members
| Member name | Value | Description | |
|---|---|---|---|
| DataBarAxisAutomatic | 0 | Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed. | |
| DataBarAxisMidpoint | 1 | Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. | |
| DataBarAxisNone | 2 | No axis is displayed, and both positive and negative values are displayed in the left-to-right direction. |
See Also
