LibreOffice 24.8 Help
Set the minimum value for which the data bar does not start filling.
Set the maximum value for which the data bar gets completely filled.
The options for setting the minimum and maximum values are:
Automatic: Automatically sets the minimum and maximum value based on the values in the data set.
Minimum: Automatically sets the minimum value in the data set as minimum.
Maximum: Automatically sets the maximum value in the data set for maximum.
Percentile: Set the minimum and maximum as percentile value.
Value: Set the minimum and maximum as a specific value.
Formula: Set the minimum and maximum as a formula.
Set the color for positive values. It is set to blue be default.
Set the color for negative values. It is set to red by default.
Choose between color and gradient for the fill.
Set the position of vertical axis in the cell.
Automatic: Set the axis automatically
Middle: Set the vertical position to be in the middle of the cell.
None: Set the data bar to have no visible vertical axis
Choose the color of the vertical axis.
Set the minimum length of the data bar in percentage with respect to the cell length.
Set the maximum length of the data bar in percentage with respect to the cell length.
Only databar is shown. Value becomes hidden.