You're welcome, from an epidemiologically-challenged coder. On Tuesday, October 29, 2013 1:24:25 PM UTC-4, Fresno County Epidemiologists wrote: > > You sir are a life saver. I appreciate your assistance with this > code incompetent epidemiologist. > > Cheers, > > > On Tue, Oct 29, 2013 at 9:06 AM, asgallant > <[email protected]<javascript:> > > wrote: > >> I made a jsfiddle based on that code, and it works: >> http://jsfiddle.net/asgallant/Htmf7/ >> >> >> On Tuesday, October 29, 2013 11:52:34 AM UTC-4, Fresno County >> Epidemiologists wrote: >> >>> 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=** >>> 0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N**0poZ0hNV0RwT2c<http://spreadsheets.google.com/ccc?key=0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N0poZ0hNV0RwT2c> >>> var query = new google.visua**lization.Query( >>> 'http://spreadsheets.google.**com/tq?key=** >>> 0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N**0poZ0hNV0RwT2c&single=true&** >>> gid=0&output=html<http://spreadsheets.google.com/tq?key=0AgvlMLEoZV9hdFAzNjhSNUxoMmc4N0poZ0hNV0RwT2c&single=true&gid=0&output=html> >>> '); >>> >>> // Send the query with a callback function. >>> query.send(handleQueryRespon**se); >>> } >>> >>> function handleQueryResponse(r**esponse) { >>> if (response.isError()) { >>> alert('Error in query: ' + response.getMessage() + ' ' + response. >>> getDetailedMessag**e()); >>> return; >>> } >>> >>> var data = response.getDataT**able(); >>> visualization = new google.v**isualization.MotionChart(docum**ent. >>> 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/**sprea**dsheet/ccc?key=0AiFfbdok-**kQKcE** >>>>>> NRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE#**gid=0<https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0>", >>>>>> >>>>>> the key is "0AiFfbdok-**kQKcENRYmV0ZC1DcHRH**WHh4UUlHN1Z**GSVE". >>>>>> The URL of the data source is then "https://docs.google.com/**sprea* >>>>>> *dsheet/tq?key= <https://docs.google.com/spreadsheet/tq?key=><your >>>>>> key>" ("https://docs.google.com/**spre**adsheet/tq?key=0AiFfbdok-** >>>>>> kQKcE**NRYmV0ZC1DcHRHWHh4UUlHN1Z**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/** >>>>>> to**pic/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+**unsub**[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/**grou**ps/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<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] <javascript:>. >> To post to this group, send email to >> [email protected]<javascript:> >> . >> 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.
