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))
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.
Triangle | |
Rhomb | |
Circle | |
Circle20 | |
Circle40 | |
Circle60 | |
Circle80 | |
Circle100 | |
ArrowUp | |
ArrowDown | |
Square20 | |
Square40 | |
Square60 | |
Square80 | |
Square100 | |
Checkmark | |
X | |
Asterisks |
See Also
- XL3SparkHeatMap formula