Difference between revisions of "XL3SparkHorizon"
(Created page with 'Creates a horizon chart that is rendered in an Excel cell. ==Syntax== {{Code|XL3SparkHorizon( Data, Output, InRows, [Colour1], [Colour2], [Colour3], [NegativeColour1], [Negative…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
Creates a horizon chart that is rendered in an Excel cell. | Creates a horizon chart that is rendered in an Excel cell. | ||
| + | |||
| + | Double-clicking the chart, or selecting the {{Menu|FluenceXL|Format In-Cell Chart...}} right-click menu item allow the editing of the chart format using the [[SparkHorizon Chart Designer]]. | ||
==Syntax== | ==Syntax== | ||
| Line 64: | Line 66: | ||
|- | |- | ||
| {{Code|NegativesFlipped}} | | {{Code|NegativesFlipped}} | ||
| − | | Specifies whether | + | | Specifies whether negative values stretch down from the top rather than from the bottom: |
| + | {| | ||
| + | | 0 || Normal || [[File:XL3SparkHorizon NegativeNormal.png]] | ||
| + | |- | ||
| + | | 1 || Flipped || [[File:XL3SparkHorizon NegativeFlipped.png]] | ||
| + | |} | ||
|- | |- | ||
| {{Code|Label}} | | {{Code|Label}} | ||
| Line 72: | Line 79: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[SparkHorizon Chart Designer]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:In-Cell Chart Formulae]] | [[Category:In-Cell Chart Formulae]] | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
Latest revision as of 09:50, 4 July 2023
Creates a horizon chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the FluenceXL > Format In-Cell Chart... right-click menu item allow the editing of the chart format using the SparkHorizon Chart Designer.
Syntax
XL3SparkHorizon( Data, Output, InRows, [Colour1], [Colour2], [Colour3], [NegativeColour1], [NegativeColour2], [NegativeColour3], [ScaleFactor], [Minimum], [Maximum], [UseCommonScale], [MissingValueHandling], [NegativesFlipped], [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:
| ||||||
| Colour1 | The colour to use for the first positive range, or -1 or an empty parameter for default | ||||||
| Colour2 | The colour to use for the second positive range, or -1 or an empty parameter for default | ||||||
| Colour3 | The colour to use for the third positive range, or -1 or an empty parameter for default | ||||||
| NegativeColour1 | The colour to use for the first negative range, or -1 or an empty parameter for default | ||||||
| NegativeColour2 | The colour to use for the second negative range, or -1 or an empty parameter for default | ||||||
| NegativeColour3 | The colour to use for the third negative range, or -1 or an empty parameter for default | ||||||
| ScaleFactor | The horizontal scale factor to use when drawing the chart | ||||||
| Minimum | A value to use for the minimum vertical axis value, or an empty parameter to use an automatic value | ||||||
| Maximum | A value to use for the maximum vertical axis value, or an empty parameter to use an automatic value | ||||||
| UseCommonScale | Use 1 here to force all charts to use a common scale | ||||||
| MissingValueHandling | Specifies how missing values should be rendered:
| ||||||
| NegativesFlipped | Specifies whether negative values stretch down from the top rather than from the bottom:
| ||||||
| Label | Specifies the text to use in the formula cell |
