diff options
Diffstat (limited to '')
-rw-r--r-- | helpcontent2/source/text/scalc/01/databar_more_options.xhp | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/databar_more_options.xhp b/helpcontent2/source/text/scalc/01/databar_more_options.xhp new file mode 100644 index 000000000..97fee0d3e --- /dev/null +++ b/helpcontent2/source/text/scalc/01/databar_more_options.xhp @@ -0,0 +1,73 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at https://mozilla.org/MPL/2.0/. + * +--> + +<meta> + <topic id="Databar-MoreOptions" indexer="include" status="PUBLISH"> + <title id="Databar-Moreoptions" xml-lang="en-US">Databar More Options</title> + <filename>/text/scalc/01/databar_more_options.xhp</filename> + </topic> +</meta> +<body> + <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/databaroptions/DatBarOptions" id="bm_id111610564351873" localize="false"/> + <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/databaroptions/@@nowidget@@" id="bm_id121610564351873" localize="false"/> + <bookmark xml-lang="en-US" branch="index" id="bm_id651610566601713"> +<bookmark_value>conditional formatting;data bar options</bookmark_value> +<bookmark_value>data bar formatting;data bar options</bookmark_value> +<bookmark_value>data bar options;conditional formatting</bookmark_value> +</bookmark> + <h1 id="hd_id631610470827523"><variable id="databaroptions"><link href="/text/scalc/01/databar_more_options.xhp" name="More Options for Databar">Databar More Options</link></variable></h1> +<h2 id="hd_id531610472930609">Entry Values</h2> + <h3 id="hd_id661610569199542">Minimum:</h3><paragraph role="paragraph" id="par_id861610473146895"> Set the minimum value for which the data bar does not start filling.</paragraph> + <h3 id="hd_id501610569361264">Maximum:</h3><paragraph role="paragraph" id="par_id461610473163880"> Set the maximum value for which the data bar gets completely filled.</paragraph> + <paragraph role="paragraph" id="par_id791610556114310">The options for setting the minimum and maximum values are:</paragraph><list type="unordered"> <listitem> + <paragraph id="par_id621610556164264" role="listitem"><emph>Automatic:</emph> Automatically sets the minimum and maximum value based on the values in the data set.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id591610556220990" role="listitem"><emph>Minimum:</emph> Automatically sets the minimum value in the data set as minimum.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id951610556245716" role="listitem"><emph>Maximum:</emph> Automatically sets the maximum value in the data set for maximum.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id901610556259738" role="listitem"><emph>Percentile:</emph> Set the minimum and maximum as percentile value.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id621610556295743" role="listitem"><emph>Value:</emph> Set the minimum and maximum as a specific value.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id331610556326466" role="listitem"><emph>Formula:</emph> Set the minimum and maximum as a formula.</paragraph> + </listitem> +</list> + <h2 id="hd_id551610558198954">Bar Colors</h2> + <h3 id="hd_id391610569504555">Positive:</h3><paragraph role="paragraph" id="par_id611610558381528"> Set the color for positive values. It is set to blue be default.</paragraph> + <h3 id="hd_id161610569508370">Negative:</h3><paragraph role="paragraph" id="par_id451610558525398"> Set the color for negative values. It is set to red by default.</paragraph> + <h3 id="hd_id261610569510818">Fill:</h3><paragraph role="paragraph" id="par_id221610558585001"> Choose between color and gradient for the fill.</paragraph> + <h2 id="hd_id711610558701623">Axis</h2> + <h3 id="hd_id731610569777368">Position of vertical axis:</h3><paragraph role="paragraph" id="par_id901610558734975"> Set the position of vertical axis in the cell.</paragraph> +<list type="unordered"> + <listitem> + <paragraph id="par_id591610558837411" role="listitem"><emph>Automatic:</emph> Set the axis automatically</paragraph> + </listitem> + <listitem> + <paragraph id="par_id991610558892435" role="listitem"><emph>Middle:</emph> Set the vertical position to be in the middle of the cell.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id971610558965550" role="listitem"><emph>None:</emph> Set the data bar to have no visible vertical axis</paragraph> + </listitem> + </list> + <h3 id="hd_id591610569865757">Color of vertical axis:</h3><paragraph role="paragraph" id="par_id601610560622213"> Choose the color of the vertical axis.</paragraph> + <h2 id="hd_id631610560675220">Bar Lengths</h2> + <h3 id="hd_id651610569932338">Minimum bar length (%):</h3><paragraph role="paragraph" id="par_id381610560706116"> Set the minimum length of the data bar in percentage with respect to the cell length.</paragraph> + <h3 id="hd_id151610569983195">Maximum bar length (%):</h3><paragraph role="paragraph" id="par_id511610560783506"> Set the maximum length of the data bar in percentage with respect to the cell length. </paragraph> + <h2 id="hd_id821610560955981">Display bar only</h2> + <paragraph role="paragraph" id="par_id501610560981306">Only databar is shown. Value becomes hidden.</paragraph> +</body> +</helpdocument>
\ No newline at end of file |