| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3SparkLine"
(Created page with 'Creates a line, point or area chart that is rendered in an Excel cell. ==Syntax== {{Code|XL3SparkLine( Data, Output, InRows, [LineType], [LineColour], [PointColour], [NegativePo…') |
(Added link to the monochrome version) |
||
| Line 106: | Line 106: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3SparkLineM|XL3SparkLineM Formula]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:In-Cell Chart Formulae]] | [[Category:In-Cell Chart Formulae]] | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
Revision as of 17:22, 23 November 2010
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:
| ||||||
| LineType | Specifies how to plot the data:
| ||||||
| 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:
| ||||||
| Label | Specifies the text to use in the formula cell |
