Learning how to make a pie chart on Google Forms is simple. In fact, you just have to click the Responses tab to get a basic pie chart. But, for a more customizable option, you should link the form to Google Sheets or use an add-on. This guide will show you how to do both.
Table of Contents
This guide will coach you through everything you need to know about making pie charts in Google Forms and Google Sheets, but looking up individual guides to learn is not the most efficient way. When you finish this guide, we recommend you take a comprehensive G Suite course to get a solid foundation of knowledge to work from in the future.
Pie charts are circular-shaped graphs that represent data statistically. The data is divided into smaller slices similar to the pieces of a pie to illustrate the different numerical proportions. Where the pie represents 100% of the dataset, the smaller slices represent a portion of the whole.
Here are a few reasons you should use pie charts to visualize the data from Google Forms. Here are some of the most valuable reasons.
Using a pie chart allows you to view the proportions of the responses in the submitted form. This can help divide individuals into certain groups based on the given response. This can help you understand how some variables relate and how different groups respond to questions. Using a Google poll pie chart can help you understand the preferences of the group and the favored response.
A lot of data can become easier to understand if it’s presented using graphs. Every response can be represented using a pie slice. For example, you can use a Google voting pie chart to visualize how many votes an individual gets. This can save you from having to count and log the number of responses per option, as you can view the portion of responses instantly.
Using pie charts can be a great way to check the most commonly occurring result in a dataset. This allows us to gauge the responses per question and check common trends quickly. Pie charts can condense the information into an easier-to-understand format. This also helps you understand the patterns between the datasets that may seem unrelated initially.
Google Forms provides you with many possibilities for making questionnaires and conducting surveys. These forms allow the participants to fill out and submit their responses freely. It can also be used for conducting small or even large-scale surveys.
Even though Google Forms has many pre-built features that convert the responses from the participants into understandable graphs and charts, they still fall short in customization. For example, you cannot choose any kind of graph you like or alter the titles or subtitles of the charts and graphs.
Google Sheets can be used for customizing charts with the data from Google Forms. Because Google Sheets and Google Forms are integrated, Google Sheets can directly import the data from Google Forms and be used to create various charts and graphs that you can alter more freely in multiple ways.
Although Google Forms can display the data gathered from the form in pie charts, it’s not as consistent, and you can not customize any of the elements in the Google Form pie chart. To create a customizable pie chart, you have to use Google Sheets.
Let’s look at how you can link Google Forms with Google Sheets and then create a customizable pie chart in Google Sheets. Here is how to link Google Forms to Google Sheets.
Go to the Responses tab and click the Link to sheets. Then you either Create a new spreadsheet or Select existing spreadsheet. For this example, we used a new spreadsheet. Once you Create it, it will take a few seconds to import the data into Google Sheets. Once done, the spreadsheet will open in a new tab.
Here is how to change Google Form responses to a pie chart in Google Sheets:
to make a pie chart from" width="799" height="362" />
With the chart created, you can now start to customize it. To do this, you need to access the Chart editor for the pie chart. For demonstration, we will change the colors of the slices in the pie chart and the names of the title and the indicators. Here is how you can customize the chart in Google Sheets:
The are plenty of other ways you can customize the chart either in the editor or simply by clicking sections of the chart. For example, to change the slices’ text labels, double-click on the label to view the edit textbox. Then you can simply type in the new label.
All edits made to the chart will be saved instantly in Google Sheets. For a more detailed explanation, you can learn more about how to make a pie chart in Google Sheets.
With the pie chart created, you can download it locally to your computer.
To do this, click the vertical ellipsis on the chart to open a drop-down menu. Here, click on the Download button. You can then select the format you wish to download the chart in. You can select between a PNG image, PDF document, or Scalable Vector Graphics. Choose the desired format, and Google Sheets will begin the download.
Sometimes a pie chart may not be the best way to display the information, for more details on picking the right chart, feel free to check out our article on everything to know about Google Sheets charts.
Adding a pie chart on Android or iOS is similar to how it’s done on a desktop. Google Forms does not have a dedicated application on mobile, which means you have to use a web browser to link to Google Sheets. You can follow the same steps as a desktop to open Google Forms on mobile. In Google Forms, click on Responses and then click on the Link to Sheets button. This will export the data onto Google Sheets.
Here is how to create a pie chart for Google Forms data on mobile:
to make a chart on mobile" width="798" height="449" />
There are several extensions and add-ons you can use to get more control over the data in Google Forms, to avoid having to use Google Sheets for data visualization. You can also use the official Apps Script language by Google, which allows you to program new functionality into Google Forms, but this is an advanced skill that is often more trouble than it’s worth when compared to just exporting to Sheets.
Google Workplace Marketplace add-ons like Advanced Summary by Awesome Table are great for creating charts and filters based on the form responses.
To install an add-on, just navigate to the 3 dot menu and click add-ons. Then, search for the add-on you want and click install.
Pie charts indicate percentages at a specific point in time and can be used to display portions of whole data sets. They can be helpful for displaying the proportions of different groups of relevant data. It is simpler than other graphs and charts and is useful for visually summarizing a large amount of data.
You can link Google Forms with Sheets to create a custom graph using the data exported from Google Forms. To create a chart, click and drag to select the data in Google Sheets and click on Insert in the top bar. Here, click on the Chart option, which will add a chart to the spreadsheet. You can customize the chart by going to the Chart editor.
Unfortunately, you can’t change the default chart type. But you can instead link the form results to Google Sheets and then use whichever chart type you’d like.
Remember that before creating the Google pie chart survey graph, we have to link Google Forms with Google Sheets to get the most customizable pie graph. But you could also use an add-on if you’d like. Those are the two key takeaways from this guide teaching you how to make a pie chart on Google Forms.
Want to become a pro in Google Forms and Sheets? Take our masterclass!
Related: