ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Basic Example
2
ValueOutputFormula
3
12
=SPARKLINE(A3,{"charttype","bar";"max",30})
4
25
=SPARKLINE(A4,{"charttype","bar";"max",30})
5
7
=SPARKLINE(A5,{"charttype","bar";"max",30})
6
17
=SPARKLINE(A6,{"charttype","bar";"max",30})
7
26
=SPARKLINE(A7,{"charttype","bar";"max",30})
8
29
=SPARKLINE(A8,{"charttype","bar";"max",30})
9
13
=SPARKLINE(A9,{"charttype","bar";"max",30})
10
Text#N/A
=SPARKLINE(A10,{"charttype","bar";"max",30})
Gives an error with text input
11
#N/A
=SPARKLINE(A11,{"charttype","bar";"max",30})
Gives an error for blank cells
12
13
14
Two series with max value
15
Value 1Value 2OutputFormula
16
517
=SPARKLINE(A16:B16,{"charttype","bar";"max",40})
17
1812
=SPARKLINE(A17:B17,{"charttype","bar";"max",40})
18
1818
=SPARKLINE(A18:B18,{"charttype","bar";"max",40})
19
520
=SPARKLINE(A19:B19,{"charttype","bar";"max",40})
20
2016
=SPARKLINE(A20:B20,{"charttype","bar";"max",40})
21
165
=SPARKLINE(A21:B21,{"charttype","bar";"max",40})
22
519
=SPARKLINE(A22:B22,{"charttype","bar";"max",40})
23
24
25
Two series with as stacked percentage chart
26
Method 1
27
Value 1Value 2OutputFormula
28
23%77%
=SPARKLINE($A27:$B27,{"charttype","bar";"max",1})
29
60%40%
=SPARKLINE($A28:$B28,{"charttype","bar";"max",1})
30
76%24%
=SPARKLINE($A29:$B29,{"charttype","bar";"max",1})
31
21%79%
=SPARKLINE($A30:$B30,{"charttype","bar";"max",1})
32
33
Method 2
34
Value 1Value 2OutputFormula
35
165
=SPARKLINE($A33:$B33,{"charttype","bar";"max",sum($A33,$B33)})
36
519
=SPARKLINE($A34:$B34,{"charttype","bar";"max",sum($A34,$B34)})
37
38
39
Changing colors
40
OptionValue 1Value 2OutputFormula
41
color1275
=SPARKLINE($B39:$C39,{"charttype","bar";"max",SUM($B39,$C39);"color1","red"})
42
color22334
=SPARKLINE($B40:$C40,{"charttype","bar";"max",SUM($B40,$C40);"color1","red";"color2","black"})
43
44
45
Advanced options
46
OptionValue 1Value 2Value 3OutputFormula
47
color1 & color2875
=sparkline($B45:$D45,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66"})
48
empty - zero66
=sparkline($B46:$D46,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66";"empty","zero"})
49
empty - ignore14
=sparkline($B47:$D47,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66";"empty","ignore"})
50
nan - convert4text2
=sparkline($B48:$D48,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66";"nan","convert"})
51
nan - ignore5text1
=sparkline($B49:$D49,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66";"nan","ignore"})
52
rtl518
=sparkline($B50:$D50,{"charttype","bar";"max",30;"color1","#009900";"color2","#66ff66";"rtl",true})
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100