Creates a line, point or area chart that is rendered in an Excel cell.
Syntax
XL3SparkLine( Data, Output, InRows, [LineType], [LineColour], [PointColour], [NegativePointColour], [PeriodLength], [PeriodColour], [StartColour], [EndColour], [MinColour], [MaxColour], [ReferenceValues], [ReferenceColour], [Minimum], [Maximum], [UseCommonScale], [NormalLowerBounds], [NormalUpperBounds], [NormalBandColour], [AreaColour], [ScaleFactor], [MissingValueHandling], [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
|
|
| LineType
|
Specifies how to plot the data:
| 0 |
Points only
|
| 1 |
Line only
|
| 2 |
Line with points
|
|
| LineColour
|
The colour to use for the line
|
| PointColour
|
The default colour to use for the data points
|
| NegativePointColour
|
The default colour to use for negative data points
|
| PeriodLength
|
The length of the period for alternate background shading
|
| PeriodColour
|
The colour of the alternate background shading
|
| StartColour
|
The colour to highlight the first point, or -1 or an empty parameter for none
|
| EndColour
|
The colour to highlight the last point, or -1 or an empty parameter for none
|
| MinColour
|
The colour to highlight the lowest point, or -1 or an empty parameter for none
|
| MaxColour
|
The colour to highlight the highest point, 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
|
| NormalLowerBounds
|
A value or range to use for the lower bounds of the normal bands
|
| NormalUpperBounds
|
A value or range to use for the upper bounds of the normal bands
|
| NormalBandColour
|
The colour to use for the normal band, or -1 or an empty parameter for none
|
| AreaColour
|
The colour to fill the chart area under the line, or -1 or an empty parameter for none
|
| ScaleFactor
|
The horizontal scale factor to use when drawing the chart
|
| MissingValueHandling
|
Specifies how missing values should be rendered:
| 0 |
Don't plot points for missing values
|
| 1 |
Plot missing values as zero
|
| 2 |
Interpolate a value for missing values
|
|
| Label
|
Specifies the text to use in the formula cell
|
See Also
