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:

Capture 2017-07-01 at 15.03.10.png

Then type in the STACKEDSPARKLINE formula in the area you would like to display the outcome:

Capture 2017-07-01 at 15.04.37.png

By adding the values you would like to calculate the STACKEDSPARKLINE formula for, Excellentable will generate the outcome:

Capture 2017-07-01 at 15.05.46.png

There were errors rendering macro:

An unknown error occurred.