XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SparkHorizon Chart Designer"
Line 1: | Line 1: | ||
+ | [[Image:sparkhorizon.png|350px|centre]] | ||
+ | |||
This dialog is used to format any SparkHorizon In-Cell Charts in your report. | This dialog is used to format any SparkHorizon In-Cell Charts in your report. | ||
Revision as of 14:30, 16 March 2015
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.
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
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