Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / AREASPARKLINE
In This Topic
    AREASPARKLINE
    In This Topic

    This function returns a data set used for representing an area sparkline.

    Syntax

    AREASPARKLINE(points, [min, max, line1, line2, colorPositive, colorNegative])

    Arguments

    This function has the following arguments:

    Argument Description
    Points

    A cell range. Invalid numbers are ignored.
    Min

    (Optional) A number that represents the minimum value of the sparkline.
    Max

    (Optional) A number that represents the maximum value of the sparkline.
    Line1

    (Optional) A number that represents a horizontal line's vertical position.
    Line2

    (Optional) A number that represents a second horizontal line's vertical position.
    ColorPositive

    (Optional) A string that represents the area color of positive values.
    ColorNegative

    (Optional) A string that represents the area color of negative values.

    Data Types

    Returns sparkline.

    Example

    activeSheet.setFormula(6, 0, '=AREASPARKLINE(A1:A6,-15,15,5,-5,"red","green")');