5
votes
Possible to add a third color to a 'bar' sparkline?
Although it is not documented in SPARKLINE function (Google Docs support) you can now specify more than 2 colors using the same color[#] syntax that is used for the first two colors.
For example, the ...
- 51
4
votes
Accepted
How to make a bold sparkline in Google Sheets?
Yes, it is parameter linewidth.
Example : =SPARKLINE(L4:L;{"linewidth"\3})
Reminder on how to construct a =sparkline :
=SPARKLINE("range",{"charttype"\"line","xmin"\0,"ymin"\0,"color"\"orange","...
- 2,030
3
votes
How to make a SPARKLINE with text (data label) in Google Sheets
Google Sheets creates sparklines via formulas so it's not possible to
have the value and the sparkline bar at the same cell. You can put
them in adjacent cells and remove the border so it'll look like ...
- 31
2
votes
Possible to add a third color to a 'bar' sparkline?
From the question:
Is there a way to set the 3rd color to be different from the first color?
No, there isn't.
According the the SPARKLINE official help article, the options for a SPARKLINE bar chart ...
1
vote
Accepted
SPARKLINE function with LOWCOLOR and YMIN doesn't get along very well
I don't know if that is realy possible, but what about a result like this?
the cell below has the same sparkline formula but with "charttype", "winloss"
- 2,416
1
vote
Possible to add a third color to a 'bar' sparkline?
You may switch the color by add "a3bc9f" (the color code in double citation mark) to change the color.
Like this: =SPARKLINE(B4:C4,{"charttype","bar";"color1",...
- 19
Only top scored, non community-wiki answers of a minimum length are eligible