| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SparkColumns Chart Designer"
(Created page with 'This dialog is used to format any SparkColumns In-Cell Charts in your report. For details about how to invoke the dialog, see In-Cell Chart Designer. ==Chart Options== ===G…') |
(Added See Also section (formula reference)) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Image:sparkcolumns.png|350px]] | ||
| + | |||
This dialog is used to format any SparkColumns In-Cell Charts in your report. | This dialog is used to format any SparkColumns In-Cell Charts in your report. | ||
| Line 56: | Line 58: | ||
; Custom value | ; Custom value | ||
: Allows selection of a custom value or values for the reference line data points | : Allows selection of a custom value or values for the reference line data points | ||
| + | |||
| + | ==See Also== | ||
| + | * [[XL3SparkColumns]] formula | ||
| + | * [[XL3SparkColumnsM]] formula | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
| + | [[Category:In-Cell Chart Designers]] | ||
Latest revision as of 09:45, 5 June 2015
This dialog is used to format any SparkColumns In-Cell Charts in your report.
For details about how to invoke the dialog, see In-Cell Chart Designer.
Contents
[hide]Chart Options
General
- 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)
- Column colour
- The default colour to use for the columns
- Negative point colour
- The default colour to use for negative columns
- Column width
- The width of each column
Column highlighting
- Minimum value colour
- The colour to highlight the lowest column
- Maximum value colour
- The colour to highlight the highest column
- Start value colour
- The colour to highlight the first column
- End value colour
- The colour to highlight the last column
Axis Options
Vertical Scale
- Automatic common scale
- If selected, overrides all the other vertical scale options and chooses one set of scales to suit all the charts controlled by this formula or member
Minimum
- Automatic
- Selects a suitable minimum for each chart individually
- Custom
- Specifies the minimum for all charts
Maximum
- Automatic
- Selects a suitable maximum for each chart individually
- Custom
- Specifies the maximum for all charts
Period
- No period colour
- Disables alternate column shading
- Period colour
- Enables alternate column shading, allowing you to specify the alternate colour for positive and negative columns, and the length of the period
Reference Line Options
- No reference line
- Disables the reference line
- Reference line
- Renders a reference line on each chart, and allows you to specify further options
- Reference line colour
- The colour for the reference line
- Automatic average
- Specifies that the reference line should be calculated as the mean of all the values in the chart
- Custom value
- Allows selection of a custom value or values for the reference line data points
See Also
- XL3SparkColumns formula
- XL3SparkColumnsM formula
