Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / MONTHSPARKLINE
In This Topic
    MONTHSPARKLINE
    In This Topic

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

    Syntax

    MONTHSPARKLINE(year, month, dataRange, emptyColor, startColor, middleColor, endColor)

    MONTHSPARKLINE(year, month, dataRange, colorRange)

    Arguments

    This function has the following arguments:

    Argument Description
    year

    A full year number, such as 2017.
    month

    A month number, such as 3. The month is 1-based (Jan = 1).
    dataRange

    A reference that represents a range where the first column is a date and the second column is a number, such as "A1:B400".
    emptyColor

    A color string that represents days with no value or zero value, such as "lightgray".
    startColor

    A color string that represents the minimum day value, such as "lightgreen".
    middleColor

    A color string that represents the day with the average minimum and maximum value, such as "green".
    endColor

    A color string that represents the day with the maximum value, such as "darkgreen".
    colorRange

    A reference that represents a range where the data is a color string.

    Data Types

    Returns sparkline.

    Example

    activeSheet.setFormula(6, 2, '=MONTHSPARKLINE(2017,1,A2:B32,"yellow","lightgreen","green","darkgreen")');