| 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 thin |
| 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 |
| 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 summariz |
| 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 http://anandexcels.wordpress.com/2012/02/09/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 yo |
| 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 charthave a look at the following link https://docs.google.com/spreadsheet/ccc?key=0AjeH8BMrOPivdC1aNEhaMVVSemJMdG9oRUhCUDdRU2c 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 !! Ho |
| 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"}) |