SpreadJS Documentation
Creating an Area Sparkline

You can create an area sparkline using the AreaSparkline formula and cell values.

The area sparkline formula has the following options:

Option Description
Points A cell range. Invalid numbers are ignored.
Min A number that represents the minimum value of the sparkline. This setting is optional.
Max A number that represents the maximum value of the sparkline. This setting is optional.
Line1 A number that represents a horizontal line's vertical position. This setting is optional.
Line2 A number that represents a second horizontal line's vertical position. This setting is optional.
ColorPositive A string that represents the area color of positive values. This setting is optional.
ColorNegative A string that represents the area color of negative. This setting is optional.

The area formula has the following format:

=AREASPARKLINE(points, min, max, line1, line2, colorPositive, colorNegative)

Using Code

This example creates an area sparkline.

JavaScript
Copy Code
activeSheet.addSpan(6, 0, 3, 4);
activeSheet.setValue(0, 0, 10);
activeSheet.setValue(1, 0, 5);
activeSheet.setValue(2, 0, 25);
activeSheet.setValue(3, 0, -5);
activeSheet.setValue(4, 0, 17);
activeSheet.setValue(5, 0, 1);
activeSheet.setFormula(6, 0, '=AREASPARKLINE(A1:A6,-15,15,5,-5,"red","green")');
activeSheet.setColumnWidth(0, 80);
activeSheet.setColumnWidth(1, 80);
activeSheet.setColumnWidth(2, 80);
activeSheet.setColumnWidth(3, 80);
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.