Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3SparkLineM

    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