Thursday, May 19, 2016

Google Tip of the Day: Embed Linked Charts into Docs and Slides

Alright Google!  You can now take data you have in Google Sheets and embed linked charts into Google Docs and Google Slides.  If you update the data in the spreadsheet you can simply click Update on the chart in the Doc or Slide and the new information will be displayed.  Here are the steps for both.
  1. Add data into Sheets and create a chart.  (example below)

    Snip20160519_1
  2. Open a new Doc or Slides presentation and click Insert>Chart>From Sheets.

    Snip20160519_2
  3. Locate the Google Sheet that contains the chart.

    Snip20160519_3
  4. Select the appropriate chart.

    Snip20160519_5
  5. If you revise the data in your original chart, the next time you open your Doc or Slide simply click the Update button to get the latest data.