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-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0";, > the key is "0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE". The URL of the > data source is then "https://docs.google.com/spreadsheet/tq?key=<your > key>" (" > 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/** >> spreadsheets#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 > . > 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.
