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.
