Creates a horizon chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the Anaplan XL > Format In-Cell Chart... right-click menu item enables 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:
|
| Colour1 | The color to use for the first positive range, or -1, or an empty parameter for default. |
| Colour2 | The color to use for the second positive range, or -1, or an empty parameter for default. |
| Colour3 | The color to use for the third positive range, or -1, or an empty parameter for default. |
| NegativeColour1 | The color to use for the first negative range, or -1, or an empty parameter for default. |
| NegativeColour2 | The color to use for the second negative range, or -1, or an empty parameter for default. |
| NegativeColour3 | The color 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:
|
| NegativesFlipped | Specifies whether negative values stretch down from the top rather than from the bottom:
|
| Label | Specifies the text to use in the formula cell. |
