SpreadJS 15
Formula Reference / Formula Functions / Sparkline Functions / SPREADSPARKLINE
In This Topic
    SPREADSPARKLINE
    In This Topic

    This function returns a data set used for representing a spread sparkline.

    Syntax

    SPREADSPARKLINE(points, [showAverage, scaleStart, scaleEnd, style, colorScheme, vertical])

    Arguments

    Argument Description
    points A reference that represents a range of cells that contains the values, such as "A1:A10".
    showAverage (Optional) A boolean that represents whether to show the average. The default value is false.
    scaleStart (Optional) A number that represents the minimum boundary of the sparkline. The default value is the minimum of all values.
    scaleEnd (Optional) A number that represents the maximum boundary of the sparkline. The default value is the maximum of all values.
    style (Optional) A number that references the style of the Spread sparkline. The default value is 4 (poles).
    colorScheme (Optional) A string that represents the color of the sparkline. The default value is "#646464".
    vertical (Optional) A boolean that represents whether to display the sparkline vertically. The default value is false.

    Data Types

    Returns sparkline.

    Examples

    activeSheet.setFormula(2, 2, '=SPREADSPARKLINE(B3:B20,TRUE,,,4,"green")');