back arrowAll articles

How to Turn Google Forms Results into a Pie Chart

Last Updated: Fri Jun 21 2024

Turning a Google Form into a pie chart is easy with the following 6 steps. Let us show you how to turn your Google Form into a pie chart.

Steps:

  • Go to the "Responses" Tab
  • Link Your Form to Google Sheets
  • Prepare Your Data in Google Sheets
  • Inserting the Pie Chart
  • Customize Your Pie Chart
  • Download or Share Your Pie Chart

Step 1: Go to the "Responses" Tab

Open your Google Form. At the top of the page, you'll find several tabs. Click on the ‘Responses’ tab to view all the submissions you've received.

red arrow pointing to ‘Responses’ tab in google forms

Step 2: Link Your Form to Google Sheets

Look for a green spreadsheet icon labeled "View in Sheets" at the top right of the Responses section. Click on it.

red arrow pointing to google sheet icon

If it's your first time linking to Sheets, a prompt will ask you to create a new spreadsheet or select an existing one.

prompt that asking to create a new spreadsheet or select an existing one

Choose "Create new spreadsheet" and it will open in a new tab.

red arrow pointing to create a new spreadsheet in a prompt

The sheet will open in a few seconds in a new tab.

google sheet titled “Pie Chart Example (Responses)”

Step 3: Prepare Your Data in Google Sheets

In Google Sheets, locate the column with the question you want to analyze.

red arrow pointing to column B tilted “Which season you like most” in google sheet

For our example, the question was "Which season do you like the most?"

Ensure you have all the responses in view.

rectangle indicates season names in google sheet

Click on the column header to highlight all the data for that question.

red arrow pointing to column B tilted “Which season you like most” when its selected

Ensure that the data does not include any irrelevant cells or titles.

red arrow pointing to a irrelevant word in a cell of google sheet

Step 4: Inserting the Pie Chart

Go to the menu bar at the top and click "Insert".

red arrow pointing to ‘Insert’ at the menu bar in google sheet

And then select "Chart".

red arrow pointing to ‘Chart’ in a menu

This will open the Chart Editor on the right side of your screen.

screenshot of Chart editor in google sheet

By default, Google Sheets will suggest a chart based on your data. However, you need to ensure it selects a Pie Chart.

red arrow pointing to ‘Pie chart’ in ‘Chart editor’

In the Chart Editor under the "Chart type" dropdown, scroll down and select "Pie chart".

red arrow pointing to pie chart from different kinds of chart

Step 5: Customize Your Pie Chart

With the pie chart selected, use the Chart Editor to make your chart more informative and visually appealing.

screenshot of Chart editor in google sheet

Click on "Customize" in the Chart Editor.

red arrow pointing to ‘Customize’ under Chart editor in google sheet

Modify the "Chart & axis titles" to add a descriptive title.

red arrow pointing to "Chart & axis titles" at the menu of ‘Customize’ in google sheet chart editor

Change the "Legend" position to where it best fits the layout.

red arrow pointing to a dropdown arrow to set the position of Legend of Pie chart in google sheet

Adjust the "Slice label" settings to display the percentage or value labels on the chart.

red arrow pointing to “Pie slice” at the menu of ‘Customize’ in google sheet chart editor

Step 6: Download or Share Your Pie Chart

When your chart looks perfect, you can either download it or share it:

To download, click on the three vertical dots on the upper-right corner of the chart.

red arrow pointing to three dots of a pie chart in google form

And select "Download".

red arrow pointing to “Download chart” from menu

Choose your preferred format (e.g., PNG, PDF).

rectangle indicates image and document type for download chart in google form

To share, click the "Share" button in the upper-right corner of the Google Sheets window and set the sharing permissions as needed.

red arrow pointing to ‘Share’ button of a google sheet

By following these detailed steps, you can turn your Google Forms responses into a detailed pie chart in Google Sheets.

This visual representation will not only make your data easier to digest but also more impactful when presenting it to others.

Back

Finished!

Vector