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 values. 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