SparkLine Chart Designer
This dialog is used to format any SparkLine or SparkArea In-Cell Charts in your report.
For details about how to invoke the dialog, see In-Cell Chart Designer.
Contents
[hide]Chart Options
General
- Title
- Specifies a title to place in the formula cell (for In-Cell Chart formulae), or to use as the member name (when used in Grids)
- Line type
- Uses the desired rendering style for the data points
| Line only | Renders only the line, without data points (except for highlighted points - see below) |
| Points only | Renders only the points, without the joining line |
| Line with points | Renders both the line and the data points |
- Line colour
- The colour to use for the line
- Point colour
- The default colour to use for the data points
- Negative point colour
- The default colour to use for negative data points
- Stretch factor
- The horizontal scale factor to use when drawing the chart
Point highlighting
- Minimum value colour
- The colour to highlight the lowest point
- Maximum value colour
- The colour to highlight the highest point
- Start value colour
- The colour to highlight the first point
- End value colour
- The colour to highlight the last point
Missing values
- Don't plot missing values
- Leave a gap where there is a gap in the source data
- Plot missing values as zero
- Substitute gaps in the source data with zeros
- Interpolate missing values
- Fill in missing values with statistically appropriate values
Axis Options
Vertical Scale
- Automatic common scale
- If selected, overrides all the other vertical scale options and chooses one set of scales to suit all the charts controlled by this formula or member
Minimum
- Automatic
- Selects a suitable minimum for each chart individually
- Custom
- Specifies the minimum for all charts
Maximum
- Automatic
- Selects a suitable maximum for each chart individually
- Custom
- Specifies the maximum for all charts
Period
- No period colour
- Disables alternate background shading
- Period colour
- Enables alternate background shading, allowing you to specify the alternate colour and the length of the period
Background Options
- No background
- Renders the chart as just lines and points (as previously specified), without additional background
- Fill area
- Renders the chart as an area chart, with the area below the line filled in the specified colour
- Normal band
- Renders a band on the chart, within which normal points are expected to fall
- Normal band colour
- The colour for the normal band
- Standard deviations
- Specifies that the normal band should be calculated as plus or minus the specified number of standard deviations from the mean
- Custom
- Allows selection of custom value or values for the minimum and maximum normal values
- Banded fill
- An extension of the normal band. See Bandline Chart Designer for more details
Reference Line Options
- No reference line
- Disables the reference line
- Reference line
- Renders a reference line on each chart, and allows you to specify further options
- Reference line colour
- The colour for the reference line
- Automatic average
- Specifies that the reference line should be calculated as the mean of all the points in the chart
- Custom value
- Allows selection of a custom value or values for the reference line data points
See Also
- XL3SparkLine formula
- XL3SparkLineM formula
- Bandline Chart Designer
