MONTHSPARKLINE

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)

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.

Returns sparkline.

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