Categories: Sheets : Report an issue :

Unable to use options in Spreadsheets' sparklines

Showing 1-11 of 11 messages
Unable to use options in Spreadsheets' sparklines EasyWebCom 2/8/12 11:30 AM
I encountered an issue while trying to create sparklines in Google Spreadsheets.
As I used only data, it had worked fine, but when I insert options, it results #ERROR! and the comment adds that it's an analysis error (errore analisi in italian, I think the translation could be right). It is so both when I define options by a reference to a range and using an array.

Here is the test file, so you can see and understand better what I want to say.

A9 is the graph without options, while B9 and B10 have options through reference and C9 - C10 through an array. Numbers 10 don't have charttype option.

I hope I explained the issue clearly.
Re: Unable to use options in Spreadsheets' sparklines Adah 2/8/12 12:23 PM
Hi there - I think you may be running into an issue of spreadsheet settings. Do you currently have your spreadsheet set on Italy under spreadsheet settings? If so, you should notice in the autocomplete guidance for the function that you need to use a semicolon in between the "data" and the "options" rather than a comma. If you try =SPARKLINE(A2:G2;A5:B6), it should work. Let me know if this helps!

Cheers,

Adah
Re: Unable to use options in Spreadsheets' sparklines EasyWebCom 2/8/12 10:24 PM
If it is so (I'll try this afternoon), the support (http://support.google.com/docs/bin/answer.py?hl=en&answer=2371371) is wrong, be' cause it uses comma instead of semicolon..
Re: Unable to use options in Spreadsheets' sparklines J0el 2/9/12 1:28 AM
I can't see any sparkline graph. Neither in my own file nor in the file from easywebcom ... why??

THX
Re: Unable to use options in Spreadsheets' sparklines EasyWebCom 2/9/12 5:44 AM
Well, I solved the issue that is explained here...actually, not at all.

If you look at the link in my first post, you can see that #ERROR! is still present in coloumn C, which is the one in which I used arrays for sparklines' options.

So, to summarize:
  • sparklines' support (http://goo.gl/c7SaS) is wrong, because it uses commas instead of semicolon between data and options
  • There is another issue (or maybe the support is wrong twice, because I followed it faithfully) with arrays (still analysis error)
This is the code I used:
  • C9: =SPARKLINE(A2:G2;{"charttype","bar";"ymin",0;"ymax",100})
  • C10:  =SPARKLINE(A2:G2;{"ymin",0;"ymax",100})
Do someone know where the problem is?

Thank you!
Re: Unable to use options in Spreadsheets' sparklines anandvarma 2/9/12 6:37 AM
Dear EasyWebCom,

Have look at the following blog post by me about the Sparkline charts


anand varma
Re: Unable to use options in Spreadsheets' sparklines EasyWebCom 2/9/12 6:52 AM
Thank you, but it does not solve my problem.
In your site you (like Google's support) use a comma between data and options, but it doesn't work for me: I must use semicolon.

You don't even solve the problem I have with arrays, since I did just like you.
Re: Unable to use options in Spreadsheets' sparklines anandvarma 2/9/12 7:31 AM
Dear EasyWebCam,

There seems to local setting problem,

Just now i have created a spread sheet with Sparkline chart
have a look at the following link



anand varma
Re: Unable to use options in Spreadsheets' sparklines EasyWebCom 2/9/12 7:38 AM
Oh, I see...indeed I was wondering if the problem could be related to the location.

However, I hope this discussion will help.
Re: Unable to use options in Spreadsheets' sparklines Jabik 11/11/12 11:53 PM
Hi EasyWebCom,

When you address the option like an object, then you should use a backslash: =SPARKLINE(A1:A5;{("charttype"\"bar")}
I copied the formula you already entered into a spreadsheet of my own and got it pasted like this.....and it works !!

Hope it works for you as well.

Ciao Jacob Jan
Re: Unable to use options in Spreadsheets' sparklines EasyWebCom 11/13/12 2:38 AM
Thank you, it works with a little variation:
=SPARKLINE(A1:A5;{"charttype"\"bar"})