Creates a column chart that is rendered in an Excel cell.
Double-clicking the chart, or selecting the Anaplan XL > Format In-Cell Chart... right-click menu item enables 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 color to use for the columns. |
| NegativeColumnColour | The default color to use for negative columns. |
| ColumnWidth | The width of each column. |
| PeriodLength | The length of the period for alternate column shading. |
| PeriodColour | The color of the alternately colored columns. |
| PeriodColour | The color of negative alternately colored columns. |
| StartColour | The color to highlight the first column, or -1 or an empty parameter for none. |
| EndColour | The color to highlight the last column, or -1 or an empty parameter for none. |
| MinColour | The color to highlight the lowest column, or -1 or an empty parameter for none. |
| MaxColour | The color 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 color 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 standard scale. |
| Label | Specifies the text to use in the formula cell. |
