Use Google Forms to Make a Pivot Chart

pivot chart

You can make a pivot chart to manipulate data collected from a Google Form survey or questionnaire. This is an excellent way to compare groups by using a bar graph. Follow the step-by-step instructions to make your own using existing data collected.

If you are using Google Forms with your students, you have likely read our previous posts: 5 Reasons to Use Google Forms with your Students, 5 More Reasons, and Google Forms and Graphed Results. This post expands on these topics.

TechnoQuestionnaire

To make the pivot chart in the activity below, you must first have created a pivot table as described in my last post. Pivot charts are another way to analyze data about subgroups in a survey population.

Follow the instructions to create a pivot chart.

  1. Open the spreadsheet with the responses that you created when making the pivot table.
  2. To view the pivot table, click the Pivot Table 1 tab at the bottom of the window.
    The table should look something like this:
pivot table
  1. Remove the Grand Totals:
    • In the Rows area, remove the checkmark in the Show totals box.
    • In the Columns area, remove the checkmark in the Show totals box.
show totals
  1. From the Insert menu, click Chart.
    • On the Start tab, click Use row 1 as header to add labels to the legend. Click Insert.
Use Row 1 as Header
  1. Drag the chart beside the pivot table.
chart and table
  1. Select the Chart title. Type Comparison of X by Y. Press ENTER.
add chart title
  1. Click on the Left vertical axis title. Type Description. Press ENTER.
  2. Click on the Horizontal axis title. Type Number of People. Press ENTER.
pivot chart
  1.  Save the chart: (optional)
    • Click the arrow on the top right corner of the chart.
    • Select Save image.

Do you prefer a pivot table or pivot chart when comparing data? Why?

Christa Love

Christa Love, Curriculum Developer & Teacher ~ I am passionate about blending technology into curriculum. Whether it is programming, video production, graphic design, or digital citizenship, I am interested in how apps and tools can be used to enhance learning. Throughout the years I have designed many TechnoKids technology projects. My favorite part of curriculum development is field-testing the ideas to determine the activities that work best in real classrooms. I write about what I have learned that can save teachers time in their own curriculum planning.

You may also like...