Use Google Forms to Make a Pivot Chart

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.


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. Make a table and a chart and consider which method you prefer to make conclusions about the survey results.

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:
  3. pivot table

  4. Remove the Grand Totals:
    1. In the Rows area, remove the checkmark in the Show totals box.
    2. In the Columns area, remove the checkmark in the Show totals box.
    3. show totals

    4. From the Insert menu, click Chart.
    5. On the Start tab, click Use row 1 as header to add labels to the legend. Click Insert.
    6. Use Row 1 as Header

    7. Click on the chart and drag it beside the pivot table.
    8. chart and table

  5. Label the chart:
    1. Click on Chart title. Type Comparison of X by Y. Press ENTER.
    2. add chart title

    3. Click on the Left vertical axis title. Type Description. Press ENTER.
    4. Click on the Horizontal axis title. Type Number of People. Press ENTER.
    5. pivot chart

  6. Save the chart: (optional)
    1. Click the arrow on the top right corner of the chart.
    2. Select Save image.
  7. Do you prefer a pivot table or pivot chart when comparing data? Why?
Christa Love

About Christa Love

Christa Love, Vice President - Christa Love has a passion for education and technology. A graduate from Brock University she has an Honors Bachelor of Arts in Child Development, Bachelor of Education in Primary and Junior divisions, and Masters of Education in the area of Curriculum Studies. Her work at TechnoKids Inc. began more than twenty years ago as an instructor at a local learning center. Since that time she has operated the summer camp program, taught at the research and development center at John Knox Christian School, trained educators throughout the province on issues related to technology integration, and overseen the curriculum development of hundreds of technology projects. In recent years, Christa has become the vice president of TechnoKids Inc.