From bd2deec2da512a3630cdadfd81cb553fb158b14a Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 17 Sep 2022 19:53:12 -0300 Subject: tdf#119421 Add details on conditional formatting data bars Change-Id: I1215e909e73dfd9707299ed98f794eea689423d9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140111 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/05120000.xhp | 3 ++ source/text/scalc/01/05120400.xhp | 98 +++++++++++++++++++++++++++------------ 2 files changed, 71 insertions(+), 30 deletions(-) (limited to 'source/text/scalc') diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index 28d08990c8..47731d53fb 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -70,6 +70,9 @@ + + +

Apply Style

Select the cell style to apply when the condition is verified. Select New Style to open the Cell Style dialog and define the style properties. diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp index ab288871e2..56d1f6ecca 100644 --- a/source/text/scalc/01/05120400.xhp +++ b/source/text/scalc/01/05120400.xhp @@ -21,31 +21,84 @@

Condition - All cells

Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range. -

Color Scale

- Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values. +
+

Color Scale

+ Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. +
+ A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values. You must choose the two "extreme" colors indicate the method of calculation. The calculation of the color applied will be made in relation to: Min - Max - Percentile - Value - Percent - Formula. The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula). For a detailed explanation and examples, please visit How to apply a Color Scale Conditional Formatting page in TDF Wiki. -

Data Bar

- Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell. Default is blue for positive and red for negative. - The calculation of the area of fill is based on Min - Max - Percentile - Value - Percent - Formula. - The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula). - More Options... opens a dialog to: +
+

Data Bar

+ Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell. +
+

Conditions

+ The calculation of the bar area fill is based on the conditions below: + + + Automatic: calculates using the minimum and maximum values in the range. + + + Min (Max): calculates using the minimum (maximum) values in the range. + + +
+ + + Value: a fixed value. Enter the value in the text box. + + + Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100. + + + Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign. + + + Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box. + + +
+ +

More Options

+ The Data Bar dialog opens to add details on the display of data bars. +

Entry values

+ Same as the conditions above. +

Bar Colors

+ Choose the color for positive and negative values. +

Fill

+ + + Gradient: set a color scale between the color of positive (negative) values and white. + + + Color: use the positive (negative) color for the entire data bar, no fade out gradient. + + +

Axis

+ Set the position of the vertical axis for the data bar. Values are + - change colors + Automatic: position the vertical axis in the middle of the maximum and minimum values. - change position of vertical axis within the cell + Middle: set the vertical axis in the middle of the column. - the bar's minimum and maximum length in percentage + None: do not display a vertical axis. +

Bar Lengths

+ Sets the minimum (maximum) length of the data bars, as a percentage of the column width. +

Display bars only

+ Do not display values in the cell, only the data bars. -

Icon Set

- Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available. +
+

Icon Set

+ Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available. +

Available Icon Sets

@@ -165,24 +218,9 @@ -

Conditions

- Conditions to set the thresholds for each icon can be specified as - - - - Value: a fixed value. Enter the value in the text box on the left. - - - Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box on the left. Valid values are from 0 to 100. - - - - Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign. - - - Formula: A formula expression starting with the equal sign (=) that calculates the numeric value for the threshold. Values can be numbers, dates or time. Enter the formula expression in the text box on the left. - - +

Conditions for thresholds

+ Conditions to set the thresholds for each icon can be specified as follows +
How to use Icon Set Conditional Formatting page in TDF Wiki.
-- cgit