Creates a horizon chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the XLCubed > Format In-Cell Chart... right-click menu item allow the editing of the chart format using the SparkHorizon Chart Designer.
Syntax
XL3SparkHorizon( Data, Output, InRows, [Colour1], [Colour2], [Colour3], [NegativeColour1], [NegativeColour2], [NegativeColour3], [ScaleFactor], [Minimum], [Maximum], [UseCommonScale], [MissingValueHandling], [NegativesFlipped], [Label] )
Parameters
| Parameter
|
Description
|
| Data
|
The data to chart. This can be a range or a formula
|
| Output
|
The target range in which to render the chart(s)
|
| InRows
|
Specifies whether the input data are in rows or columns:
| 0 |
Data are in rows
|
| 1 |
Data are in columns
|
|
| Colour1
|
The colour to use for the first positive range, or -1 or an empty parameter for default
|
| Colour2
|
The colour to use for the second positive range, or -1 or an empty parameter for default
|
| Colour3
|
The colour to use for the third positive range, or -1 or an empty parameter for default
|
| NegativeColour1
|
The colour to use for the first negative range, or -1 or an empty parameter for default
|
| NegativeColour2
|
The colour to use for the second negative range, or -1 or an empty parameter for default
|
| NegativeColour3
|
The colour to use for the third negative range, or -1 or an empty parameter for default
|
| ScaleFactor
|
The horizontal scale factor to use when drawing the chart
|
| Minimum
|
A value to use for the minimum vertical axis value, or an empty parameter to use an automatic value
|
| Maximum
|
A value to use for the maximum vertical axis value, or an empty parameter to use an automatic value
|
| UseCommonScale
|
Use 1 here to force all charts to use a common scale
|
| MissingValueHandling
|
Specifies how missing values should be rendered:
| 0 |
Don't plot points for missing values
|
| 1 |
Plot missing values as zero
|
| 2 |
Interpolate a value for missing values
|
|
| NegativesFlipped
|
Specifies whether negative values stretch down from the top rather than from the bottom:
| 0 |
Normal |
|
| 1 |
Flipped |
|
|
| Label
|
Specifies the text to use in the formula cell
|
See Also
