blob: c2c37c4b6d56bd8dfd7fd9db79046fe86463ba14 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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">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>
|
