This function returns a data set used for representing a stacked sparkline
STACKEDSPARKLINE(points, [colorRange, labelRange, maximum, targetRed, targetGreen, targetBlue, tragetYellow, color, highlightPosition, vertical, textOrientation, textSize])
This function has these arguments:
| Argument | Description |
|---|---|
| Points |
A reference that represents a range of cells that contains the values, such as "A1:A4". |
| ColorRange |
(Optional) A reference that represents a range of cells that contains all colors, such as "B1:B4". The default value is generated by color. |
| LabelRange |
(Optional) A reference that represents a cell range that contains all labels, such as "C1:C4". The default value is empty. |
| Maximum |
(Optional) A number that represents the maximum value of the sparkline. The default value is the summary of all positive values. |
| TargetRed |
(Optional) A number that represents the location of the red line. The default value is empty. |
| TargetGreen |
(Optional) A number that represents the location of the green line. The default value is empty. |
| TargetBlue |
(Optional) A number that represents the location of the blue line. The default value is empty. |
| TargetYellow |
(Optional) A number that represents the location of the yellow line. The default value is empty |
| Color |
(Optional) A string that represents the color if colorRange is omitted. The default value is "#646464". |
| HighlightPosition |
(Optional) A number that represents the index of the highlight area. The default value is empty. |
| Vertical |
(Optional) A boolean that represents whether to display the sparkline vertically. The default value is false. |
| TextOrientation |
(Optional) A number that represents the label text orientation. The default value is 0 (horizontal). The vertical setting is 1. |
| TextSize |
(Optional) A number that represents the size of the label text. The default value is 10. The unit is px. |
Returns sparkline.
activeSheet.setFormula(2, 4, '=STACKEDSPARKLINE(B3:D3,B8:D8,B2:D2,40000)');