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

    Creates an indicator icon 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 SparkIcon Chart Designer.

    Syntax

    XL3SparkIcon( Data, Output, InRows, [IconSet], [Operators], [RangeCount], [Border1], [Border2], [Border3], [Border4], [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [RangeOrder], [AltData], [AltOperators], [AltRangeCount], [AltBorder1], [AltBorder2], [AltBorder3], [AltBorder4], [AltRangeOrder], [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
    IconSet A pipe (|) delimited list of icons to use. The possible icons are listed below
    Operators A pipe (|) delimited list operators to use. The possible values are > and >=
    RangeCount The number of icon ranges to use
    Border1 The value above which the first icon should be used
    Border2 The value above which the second icon should be used
    Border3 The value above which the third icon should be used
    Border4 The value above which the fourth icon should be used. Values below this value will use the last icon
    Colour1 The colour for the first range
    Colour2 The colour for the second range
    Colour3 The colour for the third range
    Colour4 The colour for the fourth range
    Colour5 The colour for the fifth range
    RangeOrder -1 to reverse the icon order
    AltData If specified, causes the colours to be driven from this instead of the Data parameter. This can be a range or a formula
    AltOperators If AltData is specified, a pipe (|) delimited list operators to use for the colour ranges
    AltRangeCount If AltData is specified, the number of colour ranges to use
    AltBorder1 If AltData is specified, the value above which the first colour should be used
    AltBorder2 If AltData is specified, the value above which the second colour should be used
    AltBorder3 If AltData is specified, the value above which the third colour should be used
    AltBorder4 If AltData is specified, the value above which the fourth colour should be used
    AltRangeOrder If AltData is specified, -1 to reverse the colour order
    Label Specifies the text to use in the formula cell

    Icon Sets

    The following icon types are available for use with In-Cell Charts.

    SparkIconTriangle.png
    Triangle
    SparkIconRhomb.png
    Rhomb
    SparkIconCircle.png
    Circle
    SparkIconCircle20.png
    Circle20
    SparkIconCircle40.png
    Circle40
    SparkIconCircle60.png
    Circle60
    SparkIconCircle80.png
    Circle80
    SparkIconCircle100.png
    Circle100
    SparkIconArrowUp.png
    ArrowUp
    SparkIconArrowDown.png
    ArrowDown
    SparkIconSquare20.png
    Square20
    SparkIconSquare40.png
    Square40
    SparkIconSquare60.png
    Square60
    SparkIconSquare80.png
    Square80
    SparkIconSquare100.png
    Square100
    SparkIconCheckmark.png
    Checkmark
    SparkIconX.png
    X
    SparkIconAsterisks.png
    Asterisks

    See Also