Friday, January 24, 2020

Importing Tables and Graphs from Google Sheets to Google Slides

I recently had a teacher ask about linking data from a Google Sheet to a Google Slides presentation.  Specifically, was it possible to set up a template in Sheets, then have students enter lab data results and have the results easily graphed and show up automatically in Google Slides.  

Well, as luck would have it, this is a relatively new feature that has been added to Slides!  Now you'll be able to gather data and have it easily reflected in a presentation in graph form.  This has many applications beyond a Science classroom; anything from student surveys to teachers analyzing and presenting data to their collegues. Here's a quick summary of how to do it and a short tutorial video walking you through the process.

Step 1:  Highlight the cells of the data table and copy them.














Step 2: Paste them into the Google Slide.


Step 3:  Click 'Insert' on the Slides menu and choose Chart "From Sheets".
Step 4:  Find the Sheet with the Graph, select it and import it.

Step 5:  If you change any of the data in the Sheet, make sure to click the 'update' buttons in Slides

Here's the short video tutorial of the process:





No comments:

Post a Comment

Learning from YouTube - My 3 Top Viewing Tips and Tricks

Learning from watching YouTube videos is an amazing way to improve your skills.  Here are my top 3 viewing tips and tricks will help get the...