SpreadJS 15
Formula Reference / Formula Functions / Sparkline Functions / 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

    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.

    Examples

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