How can I prepare a Sparkline graph (line/bar) in a Google spreadsheet?

Question

How can I prepare a SPARKLINE graph (line/bar) in a google spreadsheet?

With the google drive help it doesn't work for me.

Reference: Google Drive Help

Answer 1

There are two ways to address a line/bar type graph. Consider the following data set:

A1:A5 = data
B1 = charttype, C1 = bar

---

First:

SPARKLINE(A1:A5;B1:C1)

Take a good look at the semicolon, in stead off the comma !!

---

Secondly:

SPARKLINE(A1:A5;{"charttype"\"bar"})

Take a good look at the backslash, in stead off the comma !!

---

Without these two modifications, making SPARKLINE graphs became very difficult for me.

Please note, that these changes may only be affected by CEST/CET time zones, see remark made by Adah (google) in the second reference.

References:

1. Google Group discussion
2. Google Drive Help