Several Different Types of Graphs on Laptop

How to Use Google Sheets to Create Graphs

January 19, 2020 5 Comments

I use Google Apps for Education almost every day in my classroom. One of my favorite ways to use Google is to have students create digital graphs.  The video below will show you, and your students, how to use Google Sheets to Create Graphs.

How do you use Google Sheets to Create a Graph?

This process can be a little complicated at first. I usually don't allow my students to make digital graphs until they have learned to make graphs by hand.  For more information on graphing in an NGSS classroom, check out this post.

However, there are so many advantages to using digital graphs.

What are the benefits of a digital graph?

Allowing students to work with a digital graph helps them to focus on the Science and Engineering Practices and Crosscutting Concepts.  When students aren't worried about the skill of graphing, they can focus on these components.

For example, digital graphing can be used to help students to focus on the practice of Analyzing and Interpreting Data.  Students can select the appropriate graph type to represent the data.  They can toggle between various graph types in order to see the benefits of one graph type over another.

By selecting the appropriate graph type, students are better able to use their data to support an argument.  Students may use the Crosscutting Concept of Patterns to determine what their data means.

Students can also focus on the Crosscutting Concept of Scale, Proportion and Quantity.  Digital graphs allow students to adjust the scale with the click of the button.  This helps reinforce their understanding of Scale.

Erin Sadler

All posts


  • Shelly April 5, 2018 at 1:39 pm

    This is awesome! I will be saving this for my students to work on making graphs in Google Sheets.

  • Melissa B. April 5, 2018 at 3:09 pm

    This was super helpful for someone who is not very good with computers! Thank you!

    • d8jdi April 6, 2018 at 1:45 am


  • Amy April 6, 2018 at 10:49 pm

    This is really cool. I think if students are able to create these graphs they will learn the material well.

  • Jeanne Wolz April 13, 2018 at 12:12 pm

    That’s awesome! May or may not want to use that for my own uses, too…
    Thanks for the post!

  • Leave a Reply

    I accept the Privacy Policy

    %d bloggers like this: