6Mf5d‖

pZFFx‖Databar More Options

PDdJA‖Entry Values

gUW4X‖Minimum:

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

FjNLX‖Maximum:

2Aauw‖ Set the maximum value for which the data bar gets completely filled.

ePnFB‖The options for setting the minimum and maximum values are:

• gBHrw‖Automatic: Automatically sets the minimum and maximum value based on the values in the data set.

• ajaES‖Minimum: Automatically sets the minimum value in the data set as minimum.

• QRiYs‖Maximum: Automatically sets the maximum value in the data set for maximum.

• Rv45U‖Percentile: Set the minimum and maximum as percentile value.

• dPLJt‖Value: Set the minimum and maximum as a specific value.

• Xo6Dm‖Formula: Set the minimum and maximum as a formula.

dtrcK‖Bar Colors

brFRN‖Positive:

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

EHFuG‖Negative:

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

Eci5i‖Fill:

SDDhg‖ Choose between color and gradient for the fill.

oQVLz‖Axis

F9wz2‖Position of vertical axis:

rqZzP‖ Set the position of vertical axis in the cell.

• GCTov‖Automatic: Set the axis automatically

• VMCSd‖Middle: Set the vertical position to be in the middle of the cell.

• 6ketG‖None: Set the data bar to have no visible vertical axis

Up8nD‖Color of vertical axis:

3HsNH‖ Choose the color of the vertical axis.

CTJaw‖Bar Lengths

V2bCh‖Minimum bar length (%):

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

zvuC5‖Maximum bar length (%):

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

5eqMJ‖Display bar only

qxGGB‖Only databar is shown. Value becomes hidden.