How can I prepare a SPARKLINE graph (line/bar) in a Google Sheets?

With the Google Drive help it doesn't work for me.

Reference: Google Drive Help.


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

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



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



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.


  1. Google Group discussion
  2. Google Drive Help

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.