| Field Summary | ||
|---|---|---|
const Number | DATA_BAR_AXIS_AUTOMATIC | |
| 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. | ||
const Number | DATA_BAR_AXIS_MIDPOINT | |
| 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. | ||
const Number | DATA_BAR_AXIS_NONE | |
| No axis is displayed, and both positive and negative values are displayed in the left-to-right direction. | ||
const Number | AUTOMATIC | |
| 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. | ||
const Number | MIDPOINT | |
| 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. | ||
const Number | NONE | |
| No axis is displayed, and both positive and negative values are displayed in the left-to-right direction. | ||
| Field Detail |
|---|
DATA_BAR_AXIS_AUTOMATIC | |
const Number DATA_BAR_AXIS_AUTOMATIC | |
DATA_BAR_AXIS_MIDPOINT | |
const Number DATA_BAR_AXIS_MIDPOINT | |
DATA_BAR_AXIS_NONE | |
const Number DATA_BAR_AXIS_NONE | |
AUTOMATIC | |
const Number AUTOMATIC | |
MIDPOINT | |
const Number MIDPOINT | |
NONE | |
const Number NONE | |