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