XL3SparkHeatMap

Creates a set of coloured icons suitable for use as a heatmap. Available from Version 8.

XL3SparkHeatMap heatmapeg.png

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 SparkHeatMap Chart Designer.

Syntax

XL3SparkHeatMap( Data, Output, InRows, Icon, HighColour, LowColour, [ColourSteps], [MidColour], [Minimum], [Maximum], [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
Icon The icon to use. The possible icons are listed below
HighColour The colour to use for the maximum value
LowColour The colour to use for the minimum value
ColourSteps The number of different colour bands
MidColour The colour to use as the mid-range colour, or -1 or an empty parameter for none
Minimum A value to use as the minimum. The value is taken from the data if no value is specified
Maximum A value to use as the maximum. The value is taken from the data if no value is specified
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