Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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