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.

ពណ៌​របារ

វិជ្ជមាន៖

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.

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.