STACKEDSPARKLINE
The stacked sparkline formula has the following options:
| Option | Description |
| Points | A reference that represents a range of cells that contains all values to be described, such as "A1:A4". |
| ColorRange | A reference that represents a range of cells that contains all colors, such as "B1:B4". This setting is optional. The default value is generated by color. |
| LabelRange | A reference that represents a cell range that contains all labels, such as "C1:C4". This setting is optional. The default value is empty. |
| Maximum | A number that represents the maximum value of the sparkline. This setting is optional. The default value is the summary of all positive values. |
| TargetRed | A number that represents the location of the red line. This setting is optional. The default value is empty. |
| TargetGreen | A number that represents the location of the green line. This setting is optional. The default value is empty. |
| TargetBlue | A number that represents the location of the blue line. This setting is optional. The default value is empty. |
| TargetYellow | A number that represents the location of the yellow line. This setting is optional. The default value is empty |
| Color | A string that represents the color if colorRange is omitted. This setting is optional. The default value is "#646464". |
| HighlightPosition | A number that represents the index of the highlight area. This setting is optional. The default value is empty. |
| Vertical | A boolean that represents whether to display the sparkline vertically. This setting is optional. The default value is false. |
| TextOrientation | A number that represents the label text orientation. This setting is optional. The default value is 0 (horizontal). The vertical setting is 1. |
| TextSize | A number that represents the size of the label text. This setting is optional. The default value is 10. The unit is px. |
Sample Usage
In order to use the STACKEDSPARKLINE formula, start with your edited Excellentable:
Then type in the STACKEDSPARKLINE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the STACKEDSPARKLINE formula for, Excellentable will generate the outcome:
Error.
User does not have sufficient privileges to access this Content
Learn More