Creates a monochrome line or point chart that is rendered in the Excel cell.

Syntax

XL3SparkLineM( Data, [LineType], [ScaleFactor], [Minimum], [Maximum], [MissingValueHandling] )

Parameters

ParameterDescription
DataThe 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
ScaleFactorThe horizontal scale factor to use when drawing the chart.
MinimumA value to use for the minimum vertical axis value or an empty parameter to use an automatic value.
MaximumA 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