How to make a pie chart in Google Forms: A step-by-step guide

Interactive step-by-step tutorial

Data drives today’s world, whether in making high-level business decisions or selecting where to have dinner. But not everyone is interested in looking at complex spreadsheets and endless numbers. 

That’s where data visualization comes in: It’s a powerful way to transform raw data into meaningful insights. One of the most popular and effective ways to visually present data is with pie charts, which provide a clear and concise picture of how a particular data set is distributed.

Whether you’re an administrator analyzing survey responses, a business leader examining customer feedback, or simply someone looking to present information in a visually appealing format, learning how to make a pie chart in Google Forms can help. Read on to learn the step-by-step process for creating informative pie charts with Google Forms, as well as an alternative tool that can help you achieve similar results.

Looking for the best alternative to Google Forms?

Looking for the best alternative to Google Forms?

Jotform’s full-featured form-building solution is mobile-friendly and has the most integrations in the industry. Use it to collect payments, automate workflows, gather leads, and more.

or
Start From Scratch

Why pie charts are important

Pie charts have distinct advantages over other data visualization formats:

  • They present data simply and clearly. Pie charts are easy to understand, even for people with little or no data analysis experience. They make it immediately apparent how a whole is subdivided into its various components, allowing any audience to quickly grasp the presented data.
  • They’re visually appealing. Stakeholders favor pie charts for professional presentations because their colorful segmentation makes data more engaging.
  • They enable comparative analysis. With multiple pie charts of the same data sets over time, you can easily compare changes and trends. Pie charts are valuable assets for tracking progress or identifying shifts in data patterns.
  • They’re simple to create. With data visualization tools like Google Forms, creating pie charts takes little time and doesn’t require advanced technical skills. This accessibility ensures anyone can generate pie charts to enhance their presentations or reports.

How to make a pie chart in Google Forms

Now that you understand why pie charts are important, we can cover how to make a pie chart in Google Forms:

  1. First, open Google Forms and select the form that contains data you want to present. If you don’t yet have a Google Form, you’ll have to create a new one and collect responses.
  2. Google Form titled “Town Hall Feedback Survey” open in edit mode, showing a multiple-choice question about how clear and understandable the information was
  1. Next, click the Responses tab.
  2. Google Forms interface with the “Responses” tab highlighted, indicating where to view collected answers
  1. You’ll now see simple pie charts representing the responses to each question.
  2. Responses summary view displaying a pie chart of survey results for the question on clarity and understanding
  1. To share the pie charts, click Copy in the upper left and paste the images where you’d like them to appear.
  2. Responses tab with a pie chart and the “Copy chart” button highlighted, showing how to copy the chart for sharing

While this process is straightforward, it doesn’t allow you to customize the chart’s text or design. Plus, you can only share them by copying and pasting the image.

Pro Tip

In the Responses tab, multiple choice and dropdown questions usually appear as pie charts. However, checkbox questions allow multiple selections, so their results are typically shown as a bar chart instead.

How to change pie chart colors in Google Forms

To customize the pie charts further, you’ll have to use Google Sheets. Here’s how to do it:

  1. In the Responses tab, click the Google Sheets icon to create a linked spreadsheet that will collect form responses.
  2. Google Forms “Responses” tab showing a pie chart summary with the “Link to Sheets” button highlighted to export responses to Google Sheets
  1. Click Create to open a new spreadsheet or open an existing one.
  2. Popup window titled “Select destination for responses” with options to create a new spreadsheet or select an existing one, and the “Create” button highlighted
  1. To create a pie chart, select the data in the column you want to display (including the column label and the data below it).
  2. Google Sheets spreadsheet with a column of survey responses selected, including the column header and multiple entries for chart creation
  1. Click on the Insert menu and select the Chart option.
  2. Google Sheets interface with the “Insert” menu open and the “Chart” option highlighted for creating a chart
  1. Select Pie chart as the chart type.
  2. Google Sheets displaying a pie chart with the chart editor panel open, showing the pie chart option selected under chart types
  1. Customize the chart’s appearance and labels in the chart editor.
  2. Google Sheets chart editor with the “Customize” tab selected, showing options to adjust pie chart appearance and labels

Once you’ve created the pie chart in Google Sheets, you can also embed it into a Google Slides presentation, share it as a link, or download it as an image to use in reports or presentations. To see these options, click on the chart, then select the three-dot menu in the top right.

How Jotform makes creating pie charts a piece of cake

Google Forms is one of the most popular online form builders, but it’s not the only free solution for collecting responses and visualizing data. Jotform features a library of over 20,000 fully customizable form templates that help users collect the data they need. What’s more, Jotform features robust data visualization and customization features built into the platform, making it a powerful alternative to Google Forms for building pie charts.

Here’s how to create a pie chart in Jotform:

  1. Open your form submissions in Jotform Tables.
  2. Click on the + Add Tab button at the top of the page.
  3. Clicking on the Add Tab Button on Jotform Tables
  1. Click on Reports, and then click the Next button.
  2. Clicking on Reports in the Create a New Tab Window
  1. Choose the form you want to show data for, then click the Next button.
  2. Choosing Straw Poll from the Forms and Clicking on Next in the Create Report View Window
  1. Select the Report View you want, then click the Next button.
  2. Selecting the Report Type in the Create Report View Window

You’ll now see an auto-generated report on all your form submissions represented as charts.

To change any chart into a pie chart, click on it. Then click the gear icon in the upper right to open the chart settings menu. You’ll then be able to select the pie chart format.

Select Pie Chart from the Chart Types Under the Chart Settings

Although the pie chart has been around since the 1700s, it remains one of the most effective and engaging formats for data visualization, offering a straightforward and intuitive way to convey complex information. Google Forms is one of the most popular online form builders, but sharing pie charts with this tool can take more time and effort than necessary. For a streamlined way to collect, visualize, and share data, try Jotform.

Photo by Julia Khalimova

AUTHOR
Elliot Rieth is a Michigan-based writer who's covered tech for the better part of a decade. He's passionate about helping readers find the answers they need, drawing on his background in SaaS and customer service. When Elliot's not writing, you can find him deep in a new book or spending time with his growing family. Find him on LinkedIn.

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Podo Comment Be the first to comment.