XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

SparkHeatMap Chart Designer

Revision as of 09:45, 5 June 2015 by Antonio.remedios (talk) (Added See Also section (formula reference))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Heatmap.png

This dialog is used to format any SparkHeatMap In-Cell Charts in your report.

For details about how to invoke the dialog, see In-Cell Chart Designer.

Title
Specifies a title to place in the formula cell (for In-Cell Chart formulae), or to use as the member name (when used in Grids)
Icon
The icon type to use in the output. See below for a list of icon types
Low colour
The colour to use for the minimum value
Mid-range colour
The colour to use for the mid-range value. Can be disabled to create a smooth range from low to high
High colour
The colour to use for the maximum value
Steps
The number of different colour bands
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

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