Sparklines in Google Sheets
I just spotted this little trick on twitter via @quantum_relic.
In a cell, enter SPARKLINE(range)
and you’ll get a line-based sparkline diagram based on your range.
Pass in the charttype
option to see it as columns SPARKLINE(range, {"charttype","column"})
. Sheets will also inform you about the other options like bar
, line
and winloss
in the formula editor.
spreadsheets, productivity, programming