XL3SparkColumns

Creates a column chart that is rendered in an Excel cell.

Syntax

XL3SparkLine( 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

• Formula Reference