Editing sparklines
To edit a sparkline, display the report in Design Mode and click the cell which contains the sparkline. The Sparkline Properties dialog is displayed.
To close the Sparkline Properties dialog, click , or click a cell outside the dialog.
The Sparkline Properties dialog has these buttons and options:
Sparkline Data
The Sparkline Data field shows the basis of the sparkline. That is, it displays Children, Descendants or, for spreadsheet based sparklines, the references of the cells which contain the source data.
Sparkline button
The button is displayed for Children and Descendants sparklines. Click it to open the Sparkline Wizard. You can change any of the parameters on which the sparkline is based but you cannot change the basis of the sparkline from Children to Descendants or from Descendant to Children.
Type
You can change the type of sparkline displayed to:
- Line
- Column
- Benchmark
- Win/Loss
- Bar
Click and select a type from the menu.
Colors
For all types of sparkline you can specify the color of the line or bars of the sparkline and whether any or all of these values will be highlighted:
- First Value
- Last Value
- Highest Value
- Lowest Value
You can specify the color used to highlight each value.
For line, column and bar sparklines, you can specify the color used to indicate negative values.
For Benchmark and Win/Loss sparklines, you can specify the color used to indicate losing values.
To specify a color, select the appropriate value-type check box and select a color from the Color Picker.
Options
For Line and Benchmark sparklines, the button is enabled.
For Line sparklines, you can specify whether markers are displayed for each data point which is not the first, last, highest or lowest value.
If markers are displayed, you can specify their color.
To specify the width of the sparkline, double-click a value in the Line Width list.
For Benchmark sparklines, you can specify the height of the benchmark and the color of the line which divides values above the benchmark from those below. The height of the benchmark can be a numerical value or it can be derived from, for example, a variable.
To specify the height of the benchmark, specify a numerical value in
the
Highlight around this
benchmark field. Or, click the browse button and specify a formula
which specifies the height of the benchmark. For example, if the height of the
benchmark is specified in a report variable, specify
="ReportVariables.[variable_name].Text" in the
Highlight around this
benchmark field.
Empty cells
You can specify how empty values are represented by a sparkline. The options are:
- Gap: Leave a gap in the sparkline
- Span: Interpolate the value from the previous and subsequent values (Line sparklines only)
- Zero: Represent the empty value as a zero value
Grouping and Axis options
If you define a sparkline in a value cell of a hyperblock, the sparkline is generated once for every element of the list and displayed in View Mode. See Hyperblocks.
For example, if you create a sparkline in the shared value cell of overlapping horizontal and vertical hyperblocks, View Mode displays sparklines in the cells of each column and row of the report.
By default, the sparklines in the columns and rows are grouped and all share the same scaling. But if, for example, there is a large variance between the high and low values in the data, the sparklines in the group might not show sufficient detail. Depending on the range of values, and on which features of the data are important to highlight, it can be useful to scale each sparkline individually. Or, you exclude unusually high or low values by specifying the minimum and maximum values.
To specify how sparklines are scaled, click and select options in the Y-Axis Minimum and Y-Axis Maximum fields. The options are:
- For whole group: All sparklines in the group share the same scaling
- For each sparkline: Each sparkline has its own scale
- User defined: The sparklines will represent only values between the minimum and maximum values which you specify
You might also want to ungroup the sparklines or specify that only the sparklines in the rows or columns of the report share the same scaling.
To specify how sparklines are grouped:
- Click the icon at the top right of the Sparkline Properties dialog. The icon indicates the current grouping option.
- Click a grouping option.
The grouping options are:
- Group All
- Group Horizontally
- Group Vertically
- Ungroup
If you have specified colors to highlight the highest and lowest values, you can specify whether highlighting applies to the group or to the individual sparklines. By default, the highest and lowest value in each sparkline are highlighted. To highlight only the highest and lowest values in the group, click .
Use the Normalize Y-Axis option to specify whether a sparkline represents actual values or the difference between them. By default, the Y-axis is normalized. That is, the difference between the values is represented.
For example, if you create a column sparkline from the spreadsheet values 10000, 10001 and 10002, the columns of the sparkline look like three steps. But if you clear the Normalize Y-Axis check box, the three columns are of the same height. That is, the difference in the actual values is too small to be represented. It is only when the values differ by approximately 500 that the differences become apparent in a non-normalized column sparkline.
If required, you can display the X-axis in sparklines and specify its color. Click and pick a color.