Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3SparkHorizon

    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 XL3SparkHorizon NegativeNormal.png
    1 Flipped XL3SparkHorizon NegativeFlipped.png
    Label Specifies the text to use in the formula cell

    See Also