| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SparkHorizon Chart Designer"
(→General: Added Flip negative data option) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[Image:sparkhorizon.png|350px | + | [[Image:sparkhorizon.png|350px]] |
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. | ||
| Line 14: | Line 14: | ||
; Stretch factor | ; Stretch factor | ||
: The horizontal scale factor to use when drawing the chart | : 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: | ||
| + | {{TableHeader}} | ||
| + | | Normal || [[File:XL3SparkHorizon NegativeNormal.png]] | ||
| + | |- | ||
| + | | Flipped || [[File:XL3SparkHorizon NegativeFlipped.png]] | ||
| + | {{TableFooter}} | ||
===Missing values=== | ===Missing values=== | ||
| Line 36: | Line 43: | ||
; Custom | ; Custom | ||
: Specifies the maximum for all charts | : Specifies the maximum for all charts | ||
| + | |||
| + | ==See Also== | ||
| + | * [[XL3SparkHorizon]] formula | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
[[Category:In-Cell Chart Designers]] | [[Category:In-Cell Chart Designers]] | ||
Latest revision as of 14:07, 5 June 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.
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
