SparkHorizon Chart Designer
This dialog is used to format any SparkHorizon In-Cell Charts in your report.
For details about how to invoke the dialog, see In-Cell Chart Designer.
Contents
[hide]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)
- Positive colours
- The colours to use for the positive regions, highest at the bottom
- Negative colours
- The colours to use for the negative regions, most negative at the bottom
- Stretch factor
- The horizontal scale factor to use when drawing the chart
- Flip negative data
- When selected, negative values stretch down from the top rather than from the bottom:
Normal | ![]() |
Flipped | ![]() |
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
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
See Also
- XL3SparkHorizon formula