| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SparkCompare"
(Created page with "Creates a Comparison Chart that is rendered in an Excel cell, this formula was introduced in Version 10 Double-clicking the chart, or selecting the XLCubed > Format In-Cell C...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
==Syntax== | ==Syntax== | ||
| − | {{Code|XL3SparkCompare( Value1, Output, InRows, ChartType, Value2, Width, ColorVal1, ColorVal2, ColorNegBar, ColorNegPop, Minimum, Maximum, AxisType, Units, TickMarks, TickMarkFormat, Label)}} | + | {{Code|XL3SparkCompare( Value1, Output, InRows, ChartType, Value2, Width, ColorVal1, ColorVal2, ColorNegBar, ColorNegPop, [Minimum], [Maximum], [AxisType], [Units], [TickMarks], [TickMarkFormat], [Label])}} |
==Parameters== | ==Parameters== | ||
| Line 87: | Line 87: | ||
| Specifies the text to use in the formula cell, if no axis is used | | Specifies the text to use in the formula cell, if no axis is used | ||
| − | + | |} | |
| + | |||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
Latest revision as of 15:06, 12 March 2020
Creates a Comparison Chart that is rendered in an Excel cell, this formula was introduced in Version 10
Double-clicking the chart, or selecting the XLCubed > Format In-Cell Chart... right-click menu item allow the editing of the chart format using the Comparison Chart Designer
Syntax
XL3SparkCompare( Value1, Output, InRows, ChartType, Value2, Width, ColorVal1, ColorVal2, ColorNegBar, ColorNegPop, [Minimum], [Maximum], [AxisType], [Units], [TickMarks], [TickMarkFormat], [Label])
Parameters
| Parameter | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Value1 | 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:
| ||||||||||
| ChartType | Choose from 4 different chart types:
| ||||||||||
| Value2 | The range of data to use for comparison. | ||||||||||
| Width | The width of the chart | ||||||||||
| ColorVal1 | The colour for a positive value, or an empty parameter for default | ||||||||||
| ColorVal2 | The color for an increase in value, or an empty parameter for default | ||||||||||
| ColorNegBar | The colour for a negative value, or an empty parameter for default | ||||||||||
| ColorNegPop | The colour for a decrease in value, or an empty parameter for default | ||||||||||
| Minimum | A value to use for the minimum horizontal axis value, or an empty parameter to use an automatic value | ||||||||||
| Maximum | A value to use for the maximum horizontal axis value, or an empty parameter to use an automatic value | ||||||||||
| AxisType | The type of axis to render in the formula cell:
| ||||||||||
| Units | The frequency of the major, labelled tickmarks | ||||||||||
| TickMarks | The number of additional labelless tickmarks per major tickmark | ||||||||||
| TickMarkFormat | The format string for the axis tickmark labels | ||||||||||
| Label | Specifies the text to use in the formula cell, if no axis is used |
