SPREADSPARKLINE

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

Syntax

SPREADSPARKLINE(points, [showAverage, scaleStart, scaleEnd, style, colorScheme, vertical])

This function has these arguments:

Argument	Description
points	A reference that represents a range of cells that contains the values, such as "A1:A10".
showAverage	(Optional) A boolean that represents whether to show the average. The default value is false.
scaleStart	(Optional) A number that represents the minimum boundary of the sparkline. The default value is the minimum of all values.
scaleEnd	(Optional) A number that represents the maximum boundary of the sparkline. The default value is the maximum of all values.
style	(Optional) A number that references the style of the Spread sparkline. The default value is 4 (poles).
colorScheme	(Optional) A string that represents the color of the sparkline. The default value is "#646464".
vertical	(Optional) A boolean that represents whether to display the sparkline vertically. The default value is false.

Returns sparkline.

activeSheet.setFormula(2, 2, '=SPREADSPARKLINE(B3:B20,TRUE,,,4,"green")');