Thank you so much.
Feel a bit stupid for not noticing that!
Thanks once again for the help!
Rita
On Saturday, March 9, 2013 10:38:56 PM UTC+1, asgallant wrote:
>
> Sorry, I think I left a introduced a typo in there somewhere. Use this
> instead:
>
> <script type="text/javascript" src="//
> ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">{"dataSourceUrl":
> "//
> docs.google.com/spreadsheet/tq?key=0AmvhaBjDaruTdC1jV0hYSV85a2F4ZU9JVG51Mk41Snc&transpose=0&headers=1&range=A1%3AF103&gid=0&pub=1","options":
>
> {"vAxes": [{"useFormatFromData": true,"title": "Left vertical axis
> title","minValue": null,"viewWindow": {"min": null,"max": null},"maxValue":
> null}, {"useFormatFromData": true,"minValue": null,"viewWindow": {"min":
> null,"max": null},"maxValue": null}],"titleTextStyle": {"fontSize":
> 16},"booleanRole": "certainty","title": "Chart title","height":
> 519,"animation": {"duration": 0},"width": 831,"hAxis":
> {"useFormatFromData": true,"title": "Horizontal axis title","minValue":
> null,"viewWindow": {"min": null,"max": null},"maxValue": null},"state":
> '{"orderedByY": false,"yZoomedIn": false,"orderedByX": false,"xLambda":
> 1,"colorOption": "2","time": "2003","sizeOption": "5","iconKeySettings":
> [],"duration": {"timeUnit": "Y","multiplier": 1},"xZoomedIn":
> false,"xZoomedDataMax": 81726000,"yZoomedDataMax": 42427,"xZoomedDataMin":
> 319000,"xAxisOption": "2","dimensions": {"iconDimensions":
> ["dim0"]},"yAxisOption": "3","playDuration": 15000,"yZoomedDataMin":
> 0,"uniColorForNonSelected": false,"yLambda": 1,"iconType":
> "BUBBLE","nonSelectedAlpha": 0.4,"showTrails": false}'},"view":
> {},"chartType": "MotionChart","chartName": "Chart 1"}</script>
>
> On Saturday, March 9, 2013 4:34:41 PM UTC-5, asgallant wrote:
>>
>> You entered the "state" as an object, but the MotionCharts expect to
>> receive it as a string. Enclose it with single-quotes and it should work:
>>
>> <script type="text/javascript" src="//
>> ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">
>> {"dataSourceUrl":"//
>> docs.google.com/spreadsheet/tq?key=0AmvhaBjDaruTdC1jV0hYSV85a2F4ZU9JVG51Mk41Snc&transpose=0&headers=1&range=A1%3AF103&gid=0&pub=1","options":{"vAxes":[{"useFormatFromData":true,"title":"Left
>>
>> vertical axis
>> title","minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},{"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}],"titleTextStyle":{"fontSize":16},"booleanRole":"certainty","title":"Chart
>>
>> title","height":519,"animation":{"duration":0},"width":831,"hAxis":{"useFormatFromData":true,"title":"Horizontal
>>
>> axis
>> title","minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},"state":'{"orderedByY":false,"yZoomedIn":false,"orderedByX":false,"xLambda":1,"colorOption":"2","time":"2003","sizeOption":"5","iconKeySettings":[],"duration":{"timeUnit":"Y","multiplier":1},"xZoomedIn":false,"xZoomedDataMax":81726000,"yZoomedDataMax":42427,"xZoomedDataMin":319000,"xAxisOption":"2","dimensions":{"iconDimensions":["dim0"]},"yAxisOption":"3","playDuration":15000,"yZoomedDataMin":0,"uniColorForNonSelected":false,"yLambda":1,"iconType":"BUBBLE","nonSelectedAlpha":0.4,"showTrails":false}'},"view":{},"chartType":"MotionChart","chartName":"Chart
>>
>> 1"} </script>
>>
>> On Saturday, March 9, 2013 4:27:09 PM UTC-5, RitaCCD wrote:
>>>
>>> Hi Asgallant,
>>>
>>> I am having exactly the same issue, my state string is not "recognized"
>>> and because of that the motion chart is always displayed in the default
>>> settings. I have looked through the code many times and I don't think my
>>> case is bracket/paretesis issue. Can you take a look?
>>>
>>> <script type="text/javascript" src="//
>>> ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">
>>> {"dataSourceUrl":"//
>>> docs.google.com/spreadsheet/tq?key=0AmvhaBjDaruTdC1jV0hYSV85a2F4ZU9JVG51Mk41Snc&transpose=0&headers=1&range=A1%3AF103&gid=0&pub=1","options":{"vAxes":[{"useFormatFromData":true,"title":"Left
>>>
>>> vertical axis
>>> title","minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},{"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}],"titleTextStyle":{"fontSize":16},"booleanRole":"certainty","title":"Chart
>>>
>>> title","height":519,"animation":{"duration":0},"width":831,"hAxis":{"useFormatFromData":true,"title":"Horizontal
>>>
>>> axis
>>> title","minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},"state":{"orderedByY":false,"yZoomedIn":false,"orderedByX":false,"xLambda":1,"colorOption":"2","time":"2003","sizeOption":"5","iconKeySettings":[],"duration":{"timeUnit":"Y","multiplier":1},"xZoomedIn":false,"xZoomedDataMax":81726000,"yZoomedDataMax":42427,"xZoomedDataMin":319000,"xAxisOption":"2","dimensions":{"iconDimensions":["dim0"]},"yAxisOption":"3","playDuration":15000,"yZoomedDataMin":0,"uniColorForNonSelected":false,"yLambda":1,"iconType":"BUBBLE","nonSelectedAlpha":0.4,"showTrails":false}},"view":{},"chartType":"MotionChart","chartName":"Chart
>>>
>>> 1"} </script>
>>>
>>>
>>> Thanks in advance
>>> Rita
>>>
>>>
>>>
>>> On Tuesday, March 5, 2013 2:24:52 AM UTC+1, asgallant wrote:
>>>>
>>>> I'm glad to hear that you got it all worked out.
>>>>
>>>> On Monday, March 4, 2013 7:25:43 PM UTC-5, Cetacea wrote:
>>>>>
>>>>> Hello asgallant,
>>>>>
>>>>> Ok, thanks *very* much, I thought I might have worn out my
>>>>> welcome.....
>>>>>
>>>>> I have just spent the last hour composing a detailed question to you,
>>>>> showing the logical steps I was making. I realise I am doing something
>>>>> wrong but could not find the issue.
>>>>>
>>>>> Just prior to me publishing my question I noted one CURLY BRACKET
>>>>> extra in my code to the left of "state". It seems I was missing this
>>>>> change?
>>>>>
>>>>> I believe I have *corrected my error* and can now load the initial
>>>>> states correctly.
>>>>>
>>>>> This is an incredible relief because I was at a loss to find what I
>>>>> was doing wrong?
>>>>>
>>>>> The code that is first generated from google spreadsheet is this: I
>>>>> was *NOT* moving/deleting the bracket immediately *before* the
>>>>> "state", marked in red...
>>>>>
>>>>> <script type="text/javascript" src="//
>>>>>> ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">
>>>>>> {"dataSourceUrl":"//
>>>>>> docs.google.com/spreadsheet/tq?key=0Am_AcfeQZNjCdFU4Y2ctNXFodE5aMmdPWGdVeXp3NVE&transpose=0&headers=1&range=A1%3AH289&gid=0&pub=1","options":{"vAxes":[{"title":"Left
>>>>>>
>>>>>> vertical axis
>>>>>> title","useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},{"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}],"titleTextStyle":{"fontSize":16},"title":"Chart
>>>>>>
>>>>>> title","booleanRole":"certainty","height":795,"animation":{"duration":0},"width":1555,"hAxis":{"title":"Horizontal
>>>>>>
>>>>>> axis
>>>>>> title","useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}
>>>>>> },"state":{},"view":{"columns":[0,1,{"label":"Urban/Rural","properties":{"role":"annotation"},"sourceColumn":2},3,4,{"label":"Region","properties":{"role":"annotation"},"sourceColumn":5},6,7]},"chartType":"MotionChart","chartName":"Chart1"}
>>>>>>
>>>>>> </script>
>>>>>
>>>>>
>>>>>
>>>>> Now that I have corrected this, all the Charts are now loading and
>>>>> showing their initial state as set.
>>>>>
>>>>> Thanks again for your patience and offer of support. It is fantastic.
>>>>>
>>>>> Regards
>>>>>
>>>>> Cet.
>>>>>
>>>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
