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:

  1. open site page you'd insert chart into.
  2. click edit page button.
  3. go insert menu, , select chart.
  4. 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.
  5. once you've selected or created chart, click ok.
  6. on next page, can adjust dimensions of chart , change title. when you've done so, click save, , chart inserted page.
keep in mind:
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

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -