Formula Parse Error in Google Spreadsheet Sparkline

Question

I'm having some trouble using the SPARKLINE function on Google Spreasheets. If I use the "default" formula, like =SPARKLINE(C9:N9), it works nicelly. But, everytime I try to add some extra options, like using columns instead of lines, for example =SPARKLINE(C11:N11;{"charttype", "bar"}), I get a "Error, Formula parse error." message.

Has anyone here had the same problem? Any idea of how can I fix it?

Thanks!

Answer 1

From https://productforums.google.com/forum/#!topic/docs/QzVhyW5bi-A

When you address the option like an object, then you should use a backslash: =SPARKLINE(C11:N11;{"charttype"\"bar"}