# STACKEDSPARKLINE

## Content

This function returns a data set used for representing a stacked sparkline

## Syntax

`STACKEDSPARKLINE(points, [colorRange, labelRange, maximum, targetRed, targetGreen, targetBlue, tragetYellow, color, highlightPosition, vertical, textOrientation, textSize])`

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

## Data Types

Returns sparkline.

## Examples

```JavaScript
activeSheet.setFormula(2, 4, '=STACKEDSPARKLINE(B3:D3,B8:D8,B2:D2,40000)');
```