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:
| 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
