summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/sparklines.xhp
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
commited5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch)
tree7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/scalc/01/sparklines.xhp
parentInitial commit. (diff)
downloadlibreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz
libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/01/sparklines.xhp')
-rw-r--r--helpcontent2/source/text/scalc/01/sparklines.xhp91
1 files changed, 91 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/sparklines.xhp b/helpcontent2/source/text/scalc/01/sparklines.xhp
new file mode 100644
index 000000000..70d9c1b0e
--- /dev/null
+++ b/helpcontent2/source/text/scalc/01/sparklines.xhp
@@ -0,0 +1,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>