Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / 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

    This function has these 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.

    Example

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