diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/sparklines.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/sparklines.xhp | 91 |
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> |