Greetings,
So I got it working this morning then something occured and I cannot get it
to work again. Please take a look at my code.
Thanks,
function drawVisualization() {
// To see the data that this visualization uses, browse to
//
http://spreadsheets.google.com/ccc?key=0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N0poZ0hNV0RwT2c
var query = new google.visualization.Query(
'
http://spreadsheets.google.com/tq?key=0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N0poZ0hNV0RwT2c&single=true&gid=0&output=html
');
// Send the query with a callback function.
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.
getDetailedMessage());
return;
}
var data = response.getDataTable();
visualization = new google.visualization.MotionChart(document.
getElementById('visualization'));
visualization.draw(data, {'width': 800, 'height':400});
On Mon, Oct 28, 2013 at 4:05 PM, asgallant <[email protected]>wrote:
> If you got the spreadsheet URL correct, then there is something else wrong
> in your code. If you post the code you are using, I can take a look and
> maybe see what the problem is.
>
>
> On Monday, October 28, 2013 6:54:49 PM UTC-4, Fresno County
> Epidemiologists wrote:
>
>> Greetings,
>>
>> I was able to pull that information out, yet the code still did not work.
>>
>>
>> On Mon, Oct 28, 2013 at 3:39 PM, asgallant <[email protected]>wrote:
>>
>>> You don't need to use the "gadget" method to get the spreadsheet URL.
>>> Look in the URL of your spreadsheet: there is a "key" parameter
>>> "key=<string of characters/numbers>", for example, in this url: "
>>> https://docs.google.com/**spreadsheet/ccc?key=0AiFfbdok-**
>>> kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE#gid=0<https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0>",
>>> the key is "0AiFfbdok-**kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE". The URL
>>> of the data source is then "https://docs.google.com/**
>>> spreadsheet/tq?key= <https://docs.google.com/spreadsheet/tq?key=><your
>>> key>" ("https://docs.google.com/**spreadsheet/tq?key=0AiFfbdok-**
>>> kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE<https://docs.google.com/spreadsheet/tq?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE>"
>>> in the example). Basically, the only significant difference between the
>>> two URL's is that one has "ccc" and the other has "tq" as the last
>>> parameter in the path.
>>>
>>>
>>> On Monday, October 28, 2013 5:43:56 PM UTC-4, [email protected]:
>>>>
>>>> Greetings Everyone,
>>>>
>>>> I am not a programmer by training, but I like to think that I am quasi
>>>> savvy in augmenting code that has already been written. Google has made
>>>> this exponentially easier with their Google Charts tool. I have
>>>> successfully created a chart that works in the Google Code Playground by
>>>> adding the data directly into the chart code. However, I would like to pull
>>>> this information from a spread sheet I have in my Google Drive.
>>>>
>>>> I visited the tutorial below:
>>>>
>>>> https://developers.google.com/****chart/interactive/docs/**spreads**
>>>> heets#Google_**Spreadsheets_as_**a_Data_Source<https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source>
>>>>
>>>> This specific step was not able to be followed: *From the spreadsheet
>>>> toolbar, click 'Insert' and choose 'Gadget'. Choose an existing gadget
>>>> or select 'Custom' as the gadget type, enter the URL of your gadget XML
>>>> specification and click 'Add'. You can choose a visualization gadget, if
>>>> you want your visualization to live in the spreadsheet; otherwise, you can
>>>> choose any gadget if you just need to get a URL to pass to an external
>>>> visualization .*
>>>> *
>>>> *
>>>> There is no Gadget from insert any longer.
>>>>
>>>> I published the spreadsheet as a website and used that URL in the code.
>>>> Any assistance with what precisely I am doing wrong would be greatly
>>>> appreciated.
>>>>
>>>> It was not helpful.
>>>>
>>>> I am trying to get data from my Google Spreadsheet to fill in my Motion
>>>> Chart from the Google Charts tool.
>>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "Google Visualization API" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/**
>>> topic/google-visualization-**api/-hrK44Bxb38/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/-hrK44Bxb38/unsubscribe>
>>> .
>>> To unsubscribe from this group and all its topics, send an email to
>>> google-visualization-api+**[email protected].
>>> To post to this group, send email to google-visua...@**googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**
>>> group/google-visualization-api<http://groups.google.com/group/google-visualization-api>
>>> **.
>>> For more options, visit
>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>> .
>>>
>>
>> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Google Visualization API" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/google-visualization-api/-hrK44Bxb38/unsubscribe
> .
> To unsubscribe from this group and all its topics, 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.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
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.
For more options, visit https://groups.google.com/groups/opt_out.
