Difference between revisions of "SparkHeatMap Chart Designer"
(Added See Also section (formula reference)) |
|||
Line 24: | Line 24: | ||
==Icon Sets== | ==Icon Sets== | ||
{{:In-Cell Chart Icon Sets}} | {{:In-Cell Chart Icon Sets}} | ||
+ | |||
+ | ==See Also== | ||
+ | * [[XL3SparkHeatMap]] formula | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
[[Category:In-Cell Chart Designers]] | [[Category:In-Cell Chart Designers]] |
Latest revision as of 10:45, 5 June 2015
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