XL3SparkHorizon

Creates a horizon chart that is rendered in an Excel cell.

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 the negative values should be flipped
Label	Specifies the text to use in the formula cell

See Also

• Formula Reference