XL3SparkColumns

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:
0 Data are in rows
1 Data are in 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

See Also