Difference between revisions of "XL3SparkLineM"
(Created page with 'Creates a line, point or area chart that is rendered in an Excel cell. ==Syntax== {{Code|XL3SparkLineM( Data, [LineType], [ScaleFactor], [Minimum], [Maximum], [MissingValueHandl…') |
(Added link to coloured version) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | Creates a line | + | Creates a monochrome line or point chart that is rendered in the Excel cell. |
==Syntax== | ==Syntax== | ||
| Line 44: | Line 44: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3SparkLine|XL3SparkLine Formula]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:In-Cell Chart Formulae]] | [[Category:In-Cell Chart Formulae]] | ||
[[Category:In-Cell Charts]] | [[Category:In-Cell Charts]] | ||
Latest revision as of 17:26, 23 November 2010
Creates a monochrome line or point chart that is rendered in the Excel cell.
Syntax
XL3SparkLineM( Data, [LineType], [ScaleFactor], [Minimum], [Maximum], [MissingValueHandling] )
Parameters
| Parameter | Description | ||||||
|---|---|---|---|---|---|---|---|
| Data | The data to chart. This can be a range or a formula | ||||||
| LineType | Specifies how to plot the data:
| ||||||
| ScaleFactor | The horizontal scale factor to use when drawing the chart | ||||||
| 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 | ||||||
| MissingValueHandling | Specifies how missing values should be rendered:
|
