YEARSPARKLINE

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

Syntax

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

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.

Returns sparkline.

activeSheet.setFormula(0, 3, '=YearSparkline(2017, A2:B' + rowCount + ', C2:C' + rowCount +')');