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…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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:
0 Points only
1 Line only
2 Line with points
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:
0 Don't plot points for missing values
1 Plot missing values as zero
2 Interpolate a value for missing values

See Also