Skip to main content

STACKEDSPARKLINE

The stacked sparkline formula has the following options:

OptionDescription
PointsA reference that represents a range of cells that contains all values to be described, such as "A1:A4".
ColorRangeA 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.
LabelRangeA reference that represents a cell range that contains all labels, such as "C1:C4". This setting is optional. The default value is empty.
MaximumA number that represents the maximum value of the sparkline. This setting is optional. The default value is the summary of all positive values.
TargetRedA number that represents the location of the red line. This setting is optional. The default value is empty.
TargetGreenA number that represents the location of the green line. This setting is optional. The default value is empty.
TargetBlueA number that represents the location of the blue line. This setting is optional. The default value is empty.
TargetYellowA number that represents the location of the yellow line. This setting is optional. The default value is empty
ColorA string that represents the color if colorRange is omitted. This setting is optional. The default value is "#646464".
HighlightPositionA number that represents the index of the highlight area. This setting is optional. The default value is empty.
VerticalA boolean that represents whether to display the sparkline vertically. This setting is optional. The default value is false.
TextOrientationA number that represents the label text orientation. This setting is optional. The default value is 0 (horizontal). The vertical setting is 1.
TextSizeA 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:


A
B
C
1
STACKEDSPARKLINE Formula
Product 1
Product 2
2
10000
20000
3
orange
purple
4
5
6
STACKEDSPARKLINE
#NAME?
D
1
Product 3
2
5000
3
yellow
4
5
6

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.