Databar More Options /text/scalc/01/databar_more_options.xhp conditional formatting;data bar options data bar formatting;data bar options data bar options;conditional formatting

Databar More Options

Entry Values

Minimum:

Set the minimum value for which the data bar does not start filling.

Maximum:

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.

Bar Colors

Positive:

Set the color for positive values. It is set to blue be default.

Negative:

Set the color for negative values. It is set to red by default.

Fill:

Choose between color and gradient for the fill.

Axis

Position of vertical axis:

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

Color of vertical axis:

Choose the color of the vertical axis.

Bar Lengths

Minimum bar length (%):

Set the minimum length of the data bar in percentage with respect to the cell length.

Maximum bar length (%):

Set the maximum length of the data bar in percentage with respect to the cell length.

Display bar only

Only databar is shown. Value becomes hidden.