Meeting people and recording their responses is the primary goal of any survey, but what if you can’t meet people? Obviously, you would just have to find a way to get your questions to them and a way to get the answers back to you. Yeah, you guessed right, an Online form like Google Forms can be a lifesaver in such situations.
But suppose that you are done with the surveys and are ready to make your reports and presentations, but how would you do that without the graphs and charts from the survey? The answer once again is Google Forms.
With Google Forms, you can get a summary of the responses with easy-to-copy graphs and charts, but in case you need something a little bit professional then you can take the help of Google Sheets to create professional-looking graphs and charts with the Google Forms data.
Can you use Google Forms to create pie charts?
Google Forms has long been providing users with the possibility of creating questionnaires and conducting online surveys. The forms allow participants to submit their responses with the utmost freedom and can be used to conduct small to large-scale online surveys.
Although Google Forms has a pre-built summary feature that converts the responses into easy-to-understand charts and graphs, they still lag behind in terms of customizations. Users are neither allowed to choose the type of graph nor can they change any titles or subtitles of the graph.
In order to make customizable charts with Goggle Forms data, you can make use of Google Sheets. Integrated with Google Forms, Google Sheets can natively export the Forms data and can be used to make all kinds of graphs and charts that can be customized in all manners.
How to make a pie chart quiz on Google Forms on PC, Android and iPhone
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. Follow the guide below to make pie charts from Google Forms.
Open Google Forms and select the form that you want to make a chart for. 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.
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.
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.
Now click on the Insert menu from the toolbar at the top.
When the Insert menu appears, select Chart to generate a chart.
Don’t worry if you don’t get a pie chart here, we can pick our own 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.
Scroll down to the Pie section and pick a pie chart. The chart on your screen will now be converted to a pie chart.
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.
Here you will get further options to customize.
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 can 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 back to 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 2D one.
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 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.
- Colour – 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 – 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 a number of 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 Colour – Lets you change the Colour of the text.
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 – 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.
When you’ve already extracted the Google Forms data onto a spreadsheet inside Google Sheets, you can convert it to a pie chart by opening the Google Sheets app on your Android device and then selecting the spreadsheet.
Select a whole row by tapping an empty cell and dragging it up to the question.
Now tap on the + icon on top of the screen to display the Insert menu.
Tap on Chart from the Insert menu.
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.
Scroll down till you find the Pie section and pick a pie chart that you like. This turns our chart into a pie chart.
Open the spreadsheet with Google Forms data in Google Sheets app on your iPhone. Inside the selected spreadsheet, select the cells whose pie chart you want to create and then, tap on the + icon to access insert options.
In the Insert menu that appears, select Chart.
On the next screen, tap on Type.
Here, scroll down to the Pie section and select a pie chart you want to apply.
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.
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 (2 Ways)
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:
Using the Download option
Once you have prepared your pie chart on Google Sheets, click on the 3-dots on its top right corner.
Now click on the Download option to show the available formats.
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.
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.
Now click on the Pictures option to be able to insert a picture.
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.
Using the Copy chart option
Another way to transfer a pie chart from Google Sheets to Microsoft Word is by clicking the 3-dots icon inside the pie chart box and then selecting the Copy chart option.
Head to the Microsoft Word file you want to copy the chart to and right-click anywhere on the document.
Now click on the Clipboard icon under ‘Paste Options’ to paste the chart in the Word file.
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 Form 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 the 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 in MS Word, Google Docs, and any other editing software that supports png. Downloading the charts as images allows you to share it 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 a number of 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.