| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SparkColumns"
(Created page with 'Creates a column chart that is rendered in an Excel cell. ==Syntax== {{Code|XL3SparkLine( Data, Output, InRows, [ColumnColour], [NegativeColumnColour], [ColumnWidth], [PeriodLen…') |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Creates a column chart that is rendered in an Excel cell. | Creates a column chart that is rendered in an Excel cell. | ||
| + | |||
| + | Double-clicking the chart, or selecting the {{Menu|XLCubed|Format In-Cell Chart...}} right-click menu item allow the editing of the chart format using the [[SparkColumns Chart Designer]]. | ||
==Syntax== | ==Syntax== | ||
| − | {{Code| | + | {{Code|XL3SparkColumns( Data, Output, InRows, [ColumnColour], [NegativeColumnColour], [ColumnWidth], [PeriodLength], [PeriodColour], [NegativePeriodColour], [StartColour], [EndColour], [MinColour], [MaxColour], [ReferenceValues], [ReferenceColour], [Minimum], [Maximum], [UseCommonScale], [Label] )}} |
==Parameters== | ==Parameters== | ||
| Line 74: | Line 76: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3SparkColumnsM|XL3SparkColumnsM Formula]] | ||
| + | * [[SparkColumns 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 11:23, 1 December 2010
Creates a column chart that is rendered in an Excel cell.
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 SparkColumns Chart Designer.
Syntax
XL3SparkColumns( Data, Output, InRows, [ColumnColour], [NegativeColumnColour], [ColumnWidth], [PeriodLength], [PeriodColour], [NegativePeriodColour], [StartColour], [EndColour], [MinColour], [MaxColour], [ReferenceValues], [ReferenceColour], [Minimum], [Maximum], [UseCommonScale], [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:
| ||||
| ColumnColour | The default colour to use for the columns | ||||
| NegativeColumnColour | The default colour to use for negative columns | ||||
| ColumnWidth | The width of each column | ||||
| PeriodLength | The length of the period for alternate column shading | ||||
| PeriodColour | The colour of the alternately coloured columns | ||||
| PeriodColour | The colour of negative alternately coloured columns | ||||
| StartColour | The colour to highlight the first column, or -1 or an empty parameter for none | ||||
| EndColour | The colour to highlight the last column, or -1 or an empty parameter for none | ||||
| MinColour | The colour to highlight the lowest column, or -1 or an empty parameter for none | ||||
| MaxColour | The colour to highlight the highest column, or -1 or an empty parameter for none | ||||
| ReferenceValues | A value or range to use for a reference line. To use the mean value instead, use "Average" | ||||
| ReferenceColour | The colour to use for the reference line, or -1 or an empty parameter for none | ||||
| 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 | ||||
| Label | Specifies the text to use in the formula cell |
