Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / YEARSPARKLINE
In This Topic
    YEARSPARKLINE
    In This Topic

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

    Syntax

    YEARSPARKLINE(year, dataRange, emptyColor, startColor, middleColor, endColor)

    YEARSPARKLINE(year, dataRange, colorRange)

    Arguments

    This function has these arguments:

    Argument Description
    year A full year number, such as 2017.
    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(0, 3, '=YearSparkline(2017, A2:B' + rowCount + ', C2:C' + rowCount +')');