Thank you ChartMan! I am actually trying to use Visualization API to run queries against spreadsheets, and output result as tables or charts to web pages on my Google Site. I am looking for the simplest way to do it. For now it looks like the only way is to create gadgets and insert them into the Google Sites pages. Or use another host for my pages with regular html/javascript.
Thanks, Liya On Jan 12, 7:42 am, ChartMan <[email protected]> wrote: > There is a new option - 'Insert > Chart'. > It let's you select a spreadsheet and insert either a chart from within > that spreadsheet or create a new chart over that sheet data. > > HTH > ChartMan > > > > > > > > On Wed, Jan 11, 2012 at 4:34 PM, alwave9 <[email protected]> wrote: > > Hi, > > > I am trying to use Google Visualization APIs on my Google Site web > > page to query and visualize data stored in Google spreadsheets. I am > > not sure what is the best way to do it: create a gadget (I am not very > > familiar how to do it) or use Apps Script module and then insert the > > script into the page. > > > When I try to use Google Visualization API (I copied some sample code > > form Google Visualization Playground samples and pasted into Apps > > Script Editor), I get this error: > > > ReferenceError: "google" is not defined. (line 3) > > > this the sample code > > > function drawVisualization() { > > // Create and populate the data table. > > var data = new google.visualization.DataTable(); - this is the line > > 3 > > data.addColumn('string', 'Task'); > > data.addColumn('number', 'Hours per Day'); > > data.addRows(5); > > data.setValue(0, 0, 'Work'); > > data.setValue(0, 1, 11); > > data.setValue(1, 0, 'Eat'); > > data.setValue(1, 1, 2); > > data.setValue(2, 0, 'Commute'); > > data.setValue(2, 1, 2); > > data.setValue(3, 0, 'Watch TV'); > > data.setValue(3, 1, 2); > > data.setValue(4, 0, 'Sleep'); > > data.setValue(4, 1, 7); > > > // Create and draw the visualization. > > new > > google.visualization.PieChart(document.getElementById('visualization')). > > draw(data, {title:"So, how was your day?"}); > > } > > > Could you kindly help me to understand how to use Visualization APIs > > in the Google Sites page? If gadgets is the only way to do it then I > > will learn how to do it, but if there is another way besides the > > gadget creation, please let me know. I have been able to create a > > stand alone html page which loads and uses the Visualization APIs, but > > Google Sites does not allow to upload html pages, and I need to > > somehow insert my code into Google Site page. > > > Maybe there is a way to load Visualization API into apps script > > editor? Unfortunately cannot find how to do it. > > > Thank you > > > Liya > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google Visualization API" group. > > To post to this group, send email to > > [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
