How to create a dynamic chart in google site with data from google spreadsheet? -
i come vietnam english not quite! please people sympathize if have written confusing! want create line chart in google site data taken google spreadsheet. if data in spreadsheet update chart in site automatically changes (like chart when insert in spreadsheet). spreadsheet response form : http://goo.gl/forms/jrjl0dcaf3
thank much!
taken verbatim here in google sites help. have italicized important information automatically updating chart.
to insert chart site, follow these steps:
keep in mind:
- open site page you'd insert chart into.
- click edit page button.
- go insert menu, , select chart.
- select spreadsheet list contains chart data you'd display.
- if spreadsheet contains chart, can select chart. snapshot of spreadsheet chart, , chart won't update if spreadsheet data modified. insert chart dynamically updates, open charts editor , select live option.
- if spreadsheet doesn't have chart in it, enter range of data. if mark live, chart update spreadsheet data modified. if mark snapshot, chart won't update unless manually so. learn more creating chart.- once you've selected or created chart, click ok.
- on next page, can adjust dimensions of chart , change title. when you've done so, click save, , chart inserted page.
anyone viewing site can view snapshot chart. if you've selected live updating chart, people have access spreadsheet able view updated version of original chart.
Comments
Post a Comment