XL3SparkLineM
Revision as of 17:09, 23 November 2010 by Antonio.remedios (talk | contribs) (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…')
Creates a line, point or area chart that is rendered in an 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:
|