Databar More Options

قيم المدخلات

الحد الأدنى:

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.

ألوان الشريط

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.

املأ:

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.