From 396d82a4d705d7b473f767816f970bffec74d33e Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 2 Jun 2022 14:56:48 -0300 Subject: tdf#148817 Sparklines Help page. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit + add bookmark entry + update Calc Insert menu help page Change-Id: I76315d7c35a2a98731ef92d9090ebcba41f9e004 Co-authored-by: Tomaž Vajngerl Co-authored-by: Roman Kuznetsov Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135324 Tested-by: Adolfo Jayme Barrientos Reviewed-by: Adolfo Jayme Barrientos --- source/text/scalc/01/sparklines.xhp | 91 +++++++++++++++++++++++++++++++++++++ source/text/scalc/main0104.xhp | 1 + 2 files changed, 92 insertions(+) create mode 100644 source/text/scalc/01/sparklines.xhp (limited to 'source') diff --git a/source/text/scalc/01/sparklines.xhp b/source/text/scalc/01/sparklines.xhp new file mode 100644 index 0000000000..05acb1c618 --- /dev/null +++ b/source/text/scalc/01/sparklines.xhp @@ -0,0 +1,91 @@ + + + + + + + Sparklines + /text/scalc/01/sparklines.xhp + + + + + + + +sparklines + +
+

Sparklines

+ Sparklines are small data charts displayed inside a cell. +
+ 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. +
+ Choose Insert – Sparklines +
+

Data

+ Input range: enter the cell range of the data. Use the shrink button to select the data range with the mouse. + Output range: select the cell range to receive the sparkline. Use the shrink button to select the cell range with the mouse. +

Properties

+ Type: select the sparkline type in the drop-down list. Choices are: + + + Line: draws a line between data values. + + + Column: draws a bar for each data value. + + + Stacked: also known as win/loss. Displays equally sized bars indicating positive and negative values. + + + Line width: enter the line width number manually or use the spin button. + Display empty cells as: choices are available in the drop-down list: + + + Gap: the missing data is not displayed. The line type discontinues in the gap and the column is not displayed. + + + Zero: the missing data is displayed as value zero. + + + Span: for line type only, draws a continuous line connecting the previous value to the next value. + + + Display hidden: 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. + Right-to-left: check to display the sparklines reverse order of the data. +

Colors

+ Series: select the main color for the sparklines. + Negative points: check and select the color for negative points. + High points: check and select the color for high points. + Low points: check and select the color for low points. + Marker: check and select the color for data points (line type only). + First point: check and select the color for first point. + Last point: check and select the color for last point. + +

Axes

+ Display X axis: check to show the X axis for sparklines. + Vertical minimum, Vertical maximum: check to set the minimum (maximum) value for the Y axis. Select one of following: + + + Individual: sets automatically the minimum (maximum) value for each sparkline based on the sparkline data range values. + + + Group: sets the minimum (maximum) value based on the lower and higher values found in the group of sparklines. + + + Custom: enter the minimum (maximum) value for the sparkline group. + + +
+ Developer blog post on sparklines +
+ + diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp index aa95eb67d4..48df92e449 100644 --- a/source/text/scalc/main0104.xhp +++ b/source/text/scalc/main0104.xhp @@ -36,6 +36,7 @@

Chart

Inserts a chart. + -- cgit