Guides · Google Forms

Google Forms · 3 min read

A pie chart from Google Forms

Google Forms can show a summary chart of its own. Teachers and team leads still export a cleaner figure for a slide or a handout. The route is the response sheet, not a plugin. Pie Chart Maker does not connect to your form.

Get a two-column summary

  1. Open the form, go to Responses, and open the green Sheets icon so the answers land in a spreadsheet.
  2. For a multiple-choice question, make a small table beside the raw answers: one row per choice.
  3. Next to each choice, count the responses. COUNTIF works: =COUNTIF(B:B, "Apples") if column B holds that question and “Apples” is the choice.
  4. Copy the choice names and the counts. Do not copy the formula cells’ formulas; the copy puts the numbers on the clipboard.
  5. Paste into the Sheets pie chart page and download a PNG for the class slide.

Checkboxes are different from multiple choice. A person can pick more than one answer, so the counts can add up to more than the number of people. A pie chart of those counts is no longer “parts of the class.” Say that in the caption, or chart “number of people who selected each option” only if you are comfortable that the slices are not a single whole. A bar chart is often clearer for checkboxes.

Short-answer questions do not chart until you group them. Count the repeated phrases yourself, or leave them as a list.

Make a pie chart