3 Ways to Make a Pie Chart on Google Forms

What to know

  • Google Forms can transform user responses into charts and graphs but to customize it further, you will need to use Google Sheets. 
  • To transfer data from Google Forms to Sheets, go to the Google Forms website > select a form > Responses tab and click on the Google Sheets icon
  • To create a pie chart inside Google Sheets, go to the Insert tab > Chart > Chart type > Pie and click on the Customize tab inside the Chart editor. 
  • Check out the post below to learn more. 

Google Forms can create questionnaires and conduct online surveys to allow participants to submit their responses with the utmost freedom. Although its summary tool can help convert the responses into easy-to-understand charts and graphs, it still lacks in terms of customizations. 

Fortunately, you can use Google Sheets to make customizable charts with the data from Google Forms. In this post, we’ll explain all the ways you can create a pie chart on Google Forms. 

How to make a pie chart quiz on Google Forms [3 methods]

If you’ve got a Google Form you want to create a pie chart from, you’ll need to rely on Google Sheets to extract the data from Forms and use this data to compile the pie chart. 

Method 1: Using Google Sheets on the web

  1. Open the Google Forms website and select the form that you want to make a chart for.
  2. When the form is open, click on the Responses tab at the top to display the data from the responses that you have received from people.
  3. Click on the Google Sheets icon next to the 3-dots icon at the top. This will open the Forms data inside a spreadsheet on Google Sheets.
  4. Once in Google Sheets, select a column by clicking on an empty cell with the mouse and scrolling upwards till you reach the cell with the question.
  5. Now click on the Insert tab from the toolbar at the top.
  6. When the Insert menu appears, select Chart to generate a chart.
  7. Don’t worry if you don’t get a pie chart here, we can pick our charts. In the chart editor which is right next to the chart, click on the drop-down arrow under “Chart type” to pick from different charts. 
  8. Scroll down to the Pie section and pick a pie chart. The chart on your screen will now be converted to a pie chart.
  9. If you want to customize the chart to your liking. You can do that by clicking on the Customize tab inside the Chart Editor sidebar on the right.
  10. Here you will get further options to customize. 
Chart Style

Chart style lets you customize the looks of the chart.

  • Background Colour – It lets you change the background Colour of the chart. You can either make it transparent by choosing none or give it a Colour as per your liking.
  • Font – It lets you choose a single font for all the numbers and letters displayed anywhere on the chart.
  • Chart Border Colour – It lets you give a border Colour to the chart. The default is mostly Dark Grey 2, but you can pick any Colour. Choosing none gives the graph a transparent border.
  • Maximize – It will increase the size of the chart to fit the area. Turning it on will maximize the chart, and turning it off returns it to the default size. When the chart is maximized, the titles for data might be placed in one corner.
  • 3D – When turned on, it will turn a 2D chart into a 3D one and when turned off, it will change the 3D chart into a 2D one.
Pie Chart

Here you will be able to customize how the Pie looks.

  • Doughnut Hole – Punches a hole in the middle of the Pie, which can be kept between 25 to 75 percent of the Pie’s size.
  • Border Colour – Lets you add a Colour to the border of the Pie.
  • Slice Label – You can add the Label to the different slices indicating the respective labels.
  • Label Font – You will be able to pick a font of your choice here.
  • Label Font Size – Choose a size for the font, you can make the font bigger or make it small enough.
  • Label Format – Changes the format of the Label. You can give it a Bold format, or the Italic format.
  • Text Colour – It will help you change the Colour of all the Label text at once.
Pie Slice

Pie Slice allows the user to customize each slice in the Pie.

  • Slice Title – Usually displayed as a drop-down menu with the slice names as options. It will allow you to choose the slice which you want to customize.
  • Color – You can change the Colour of the slice as per your liking.
  • Distance from Centre – It will allow you to separate respective slides from the center. It can be used to put focus on a single slice.
Chart and Axis titles

It allows you to change the title of the chart.

  • Chart Title/Chart Subtitle – This lets you pick between the Chart Title and Chart Subtitle so that you can tweak them individually.
  • Title Text – Lets you add or edit the text of the title.
  • Title Font – This allows you to pick from many different fonts for the title.
  • Title Font Size – You can change the size of the title to make it big or small.
  • Title Format – Add a Bold or Italic format to the title.
  • Title text Color – Lets you change the Color of the text.
Legend

The Legend menu lets you customize the look of the titles which indicate portions of the pie.

  • Position – Lets you move the titles to different corners of the chart.
  • Legend Font – It will allow you to change the Fonts for the titles.
  • Legend Font Size – This lets you pick a font size that feels better to you.
  • Legend Format – Gives a Bold or Italic format to the titles.
  • Text Colour – Pick a single Colour for all the titles.

Method 2: Using the Google Sheets app on Android 

When you’ve already extracted the Google Forms data onto a spreadsheet inside Google Sheets, you can convert it to a pie chart by following the steps below.

  1. Open the Google Sheets app on your Android device and then select the spreadsheet.
  2. Select a whole row by tapping an empty cell and dragging it up to the question.
  3. Now tap on the + icon on top of the screen to display the Insert menu.
  4. Tap on Chart from the Insert menu.
  5. You might not always get a pie chart here, so let’s try picking it from the options. Here, tap on Type to pick a specific chart.
  6. Scroll down till you find the Pie section and pick a pie chart that you like. This turns our chart into a pie chart.

Method 3: Using the Google Sheets app on iPhone

Make sure you’ve already extracted the Google Forms data into a Google Sheets file. 

  1. Open the Google Sheets app on your iPhone.
  2. Inside Google Sheets, select the spreadsheet with Google Forms data.
  3. Here, select the cells whose pie chart you want to create and then, tap on the + icon to access insert options.
  4. In the Insert menu that appears, select Chart
  5. On the next screen, tap on Type.
  6. Here, scroll down to the Pie section and select a pie chart you want to apply.
  7. Once you select a pie chart of your choice, tap on the checkmark at the top left corner of the screen to add it to your spreadsheet. 
  8. The pie chart will now show up inside Google Sheets. You can relocate and resize this chart to show up properly with other details inside the spreadsheet. 

How to transfer a pie chart from Google Forms to MS Word

If you wish to move a chart you created from Google Forms to Microsoft Word, then you can do it directly using the Google Sheets spreadsheet you created for making the pie chart above. There are two ways to transfer pie charts to MS Word:

Method 1: Using the Download option

  1. Once your pie chart is ready on Google Sheets, click on the 3-dots at the top right corner.
  2. Now click on the Download option to show the available formats.
  3. Select PNG Image (.png) to download the chart in .png format with a white background. The chart will now be downloaded to your default downloads folder.
  4. Now, launch the Microsoft Word program on your computer and open the file you want to add the pie chart to. When the document loads up, click on the Insert tab from the toolbar at the top.
  5. Now click on the Pictures option to be able to insert a picture.
  6. A pop-up menu will show up, select the image from your default download location, and click on Insert to drop it in the MS Word file.

Method 2: Using the Copy chart option

Another way to transfer a pie chart from Google Sheets to Microsoft Word is by following the steps below.

  1. Click on the 3-dots icon inside the pie chart box and then select Copy chart.
  2. Head to the Microsoft Word file you want to copy the chart to and right-click anywhere on the document.
  3. Now click on the Clipboard icon under ‘Paste Options’ to paste the chart in the Word file.

FAQs

Does Google Forms have charts?

Yes, Google Forms has pre-built summary charts, which show the summary of your responses in the form of 2D charts. You can copy the charts from the summary and paste them into any photo or text editing application, and can even take printouts of the same. The charts can be copied or downloaded as high-quality images and are very accurate for all types of reports and projects.

Are charts created from Google Forms accurate?

Making an accurate chart is mostly about asking the right question to get the required answer. A question that has random answers including both words and numbers can not be used to create a very neat and accurate chart. But if you have asked the right questions and have just the right answers, then there’s not much to worry about.

Google Forms is based on the Google Analytics framework and can produce extremely accurate aggregates of data, thus ensuring truly accurate charts and graphs in Google Sheets. Furthermore, anything that does not feel right can be customized to make sure that the chart is just the way you need it for your presentations or reports.

Is Google Forms chart useful for making reports?

Yes, a Google Forms chart can be useful for making reports. Making use of the Google Analytics framework, Google Forms ensures the accuracy of the data and can be used along with Google Sheets to produce detailed and professional-looking graphs and charts. The possibility of downloading the charts in PNG format, and being able to copy them to the clipboard ensures that the charts are highly compatible with all types of editing and report-making software.

Can I use Google Forms for school projects?

Yes, you can use Google Forms for school projects. If your project does not require you to submit specific graphs then you can simply copy the graphs from the summary and print them for your projects. But if you require different graphs for different questions, you can make use of the integrated Google sheets by following the above-mentioned steps and taking printouts once done with the graphs.

Can Google Forms Charts be copied to use somewhere else?

Yes, both Google Forms summary charts and the charts made with the Google Forms data in Google Sheets can be copied and downloaded to be used anywhere. Once copied, you will be able to paste the chart into MS Word, Google Docs, and any other editing software that supports PNG. Downloading the charts as images allows you to share them with someone over the internet or simply take printouts.

Can Google Forms Charts be customized?

Yes, Google Forms charts can be customized with the help of Google Sheets. Google Sheets lets you pick from many readily available charts, which can be customized for both looks and accuracy of the data. You can customize the looks of the charts, their labels, and titles, and tweak the data a little if it does not fit the requirements of your project.

That’s all there is to know about making a pie chart from Google Forms.