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 |