blob: 70d9c1b0eebf8e1b051f064f5bb6b2dd143fcf51 (
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
<?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 http://mozilla.org/MPL/2.0/.
*
-->
<meta>
<topic id="textscalc01sparklines.xhp" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sparklines</title>
<filename>/text/scalc/01/sparklines.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sparklinedialog/SparklineDialog" id="bm_id551654173649481" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sparklinedialog/@@nowidget@@" id="bm_id561654173649481" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id901654173679276">
<bookmark_value>sparklines</bookmark_value>
</bookmark>
<section id="sparklinesh1">
<h1 id="hd_id721654173263812"><variable id="sparklines"><link href="text/scalc/01/sparklines.xhp" name="Sparklines">Sparklines</link></variable></h1>
<paragraph id="par_id981654173263817" role="paragraph" xml-lang="en-US">Sparklines are small data charts displayed inside a cell.</paragraph>
</section>
<paragraph role="paragraph" id="par_id341654174064080">Sparklines are defined for one cell, but multiple sparklines can be joined together into a group. The group shares the same properties for rendering the sparkline. The unique data that is defined only for one sparkline is the data range, that a sparkline will use for rendering.</paragraph>
<section id="howtoget">
<paragraph role="paragraph" id="par_id761654173486733">Choose <menuitem>Insert – Sparklines</menuitem></paragraph>
</section>
<h2 id="hd_id391654173530650">Data</h2>
<paragraph role="paragraph" id="par_id751654174462868"><emph>Input range</emph>: enter the cell range of the data. Use the <emph>shrink</emph> button to select the data range with the mouse.</paragraph>
<paragraph role="paragraph" id="par_id701654174578218"><emph>Output range</emph>: select the cell range to receive the sparkline. Use the <emph>shrink</emph> button to select the cell range with the mouse.</paragraph>
<h2 id="hd_id651654174597644">Properties</h2>
<paragraph role="paragraph" id="par_id961654174732293"><emph>Type</emph>: select the sparkline type in the drop-down list. Choices are:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id481654191793887" role="listitem"><emph>Line</emph>: draws a line between data values.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id391654191798913" role="listitem"><emph>Column</emph>: draws a bar for each data value.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id481654191804474" role="listitem"><emph>Stacked</emph>: also known as win/loss. Displays equally sized bars indicating positive and negative values.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id701654174850309"><emph>Line width</emph>: enter the line width number manually or use the spin button.</paragraph>
<paragraph role="paragraph" id="par_id761654176569576"><emph>Display empty cells as</emph>: choices are available in the drop-down list:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id171654176533173" role="listitem"><emph>Gap</emph>: the missing data is not displayed. The line type discontinues in the gap and the column is not displayed.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id81654176538165" role="listitem"><emph>Zero</emph>: the missing data is displayed as value zero.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id801654176544375" role="listitem"><emph>Span</emph>: for line type only, draws a continuous line connecting the previous value to the next value.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id431654176711837"><emph>Display hidden</emph>: check to show all columns or stacks in the range even when the data is in hidden cells. If unchecked, the hidden data is ignored.</paragraph>
<paragraph role="paragraph" id="par_id21654177035348"><emph>Right-to-left</emph>: check to display the sparklines reverse order of the data.</paragraph>
<h2 id="hd_id911654177186844">Colors</h2>
<paragraph role="paragraph" id="par_id11654177765370"><emph>Series</emph>: select the main color for the sparklines.</paragraph>
<paragraph role="paragraph" id="par_id421654177770032"><emph>Negative points</emph>: check and select the color for negative points.</paragraph>
<paragraph role="paragraph" id="par_id231654177773798"><emph>High points</emph>: check and select the color for high points.</paragraph>
<paragraph role="paragraph" id="par_id371654177777479"><emph>Low points</emph>: check and select the color for low points.</paragraph>
<paragraph role="paragraph" id="par_id521654177784536"><emph>Marker</emph>: check and select the color for data points (line type only).</paragraph>
<paragraph role="paragraph" id="par_id181654177788533"><emph>First point</emph>: check and select the color for first point.</paragraph>
<paragraph role="paragraph" id="par_id241654177793144"><emph>Last point</emph>: check and select the color for last point.</paragraph>
<h2 id="hd_id251654180880861">Axes</h2>
<paragraph role="paragraph" id="par_id871654181525722"><emph>Display X axis</emph>: check to show the X axis for sparklines.</paragraph>
<paragraph role="paragraph" id="par_id891654181533521"><emph>Vertical minimum, Vertical maximum:</emph> check to set the minimum (maximum) value for the Y axis. Select one of following:</paragraph>
<list type="unordered">
<listitem>
<paragraph id="par_id521654181404234" role="listitem"><emph>Individual</emph>: sets automatically the minimum (maximum) value for each sparkline based on the sparkline data range values.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id821654181425448" role="listitem"><emph>Group</emph>: sets the minimum (maximum) value based on the lower and higher values found in the group of sparklines.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id51654181442414" role="listitem"><emph>Custom</emph>: enter the minimum (maximum) value for the sparkline group. Enter the minimum (maximum) values or use the spin buttons.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id801654192214865"><link href="https://tomazvajngerl.blogspot.com/2022/03/sparklines-in-calc.html" name="developer info">Developer blog post on sparklines</link></paragraph>
</section>
</body>
</helpdocument>
|
