Create graphs for Google Forms surveys in Google Sheets – .com

In this tutorial we will see how to create charts in Google Sheets for Google Forms and survey responses.

Google Forms and Google Sheets spreadsheets

When we need to analyze data from a Google Forms survey or form, spreadsheets can be very useful. On the one hand, they allow us to store the answers in a structured and orderly way and, on the other, they help us to analyze them.

If you are interested in taking advantage of it, especially the free tool Google Sheets, we recommend the and the , where techniques are explained to work in a more agile and efficient way.

In fact, one of the options we have, and which is detailed in one of the course lessons, is to create graphics from the responses of a Google Forms form or survey. In this way we will be able to visualize the data at a single glance, so let’s see what it would be like. Let us begin!.

Link spreadsheet and form

The first thing we will have to do is associate the responses of the Google Forms form to a spreadsheet. In this case we are going to use the Google Sheets spreadsheet since these services can be easily linked and they combine very well.

well, there is two forms to do it. If we have the form already created, we will have to access it through the official page of , and then click on the “Answers” tab.

Once here we will see a green button that corresponds to Google Sheets. If we press it, we will create a new spreadsheet so that the responses of the form are also displayed there.

See also  Premiere Course #4. Video effects and transitions - .com

The other way would be to create the form directly from Google Sheets. For this we have to previously create a spreadsheet from the application. Once we have it, we must click on the “Insert/Form” menu option.

Next, we will have to add the fields we need to it, we simply have to click on the “+” sign and add them. We see this in more detail in the first class of the .

In this case, we are going to create a test survey with a single question, which will help us to analyze which security plugin is preferred among the users who carry it out.

Once we include all the fields we need in the form, it’s time to share it and start collecting data. To do this, we would have to click on the “Send” button, which is found in the menu in the upper right area.

This will open a new window in which we can choose between sending an email, a link, or sharing on networks, among other options.

Since this is just one example, we are going to introduce ourselves several answers. We can do it by sending us the link to the form from this same window or from the preview option that is next to the “Send” button.

Once we have the link and open the form, we can fill out the survey. We will see that as we do this, new rows will be created in the Google Sheets file. These rows correspond precisely to each of the responses that we enter.

See also  Choose the role when registering in WordPress - .com

Ok, so we’ve already seen how to link the form and the spreadsheet, and we have answers in the latter. The next step will be to insert a graph that allows us to visually analyze all the data that we are collecting.

Insert chart in spreadsheet

For insert a chart in the spreadsheet that we have linked to the form, we will have to select column values that we want to appear in it and then click on the “Insert/Graphic” menu option. We can do this with all the columns that have data, so it is possible to insert more than one chart.

As soon as we do, a graph will appear on the screen. In this case, it is a column chart where the values ​​we have selected are represented, but we can choose between several types.

In fact, we can also show the results in a line, circular or bar graph, among others. To change it, we have to click on the graph that has been inserted in the spreadsheet and then access the “Graphic Editor” that will appear on the right.

Then we must click on the “Graph Type” option and choose the one that best suits the data we are collecting.

From this same menu we can also perform other actions such as modifying the associated text or changing the style of the graphic. In the “Customize” tab we have some of them.

And that’s all! As we can see, linking a Google Forms form with a Google Sheets spreadsheet, and creating graphs where the responses are displayed is quick and easy. In a few steps we will have them ready and they will allow us to examine the results with the naked eye, thus helping us in the analysis tasks.

See also  Video game creation course - .com

Summary and conclusion

Google Sheets is a very powerful tool with which we can process, analyze and visualize data. In the tutorial we have seen how to use it together with Google Forms to create a graph with the responses of a survey.

To do this we must perform a few simple steps. First we will link the spreadsheet and the form as we have seen. Later, we will select the information that we want to visualize with a graph, and we will insert it.

And as always, you already know. If you want to learn more, we recommend the courses. If you subscribe, you will have access to and to , in addition to all the others. There are more than available, we are waiting for you! 🙂

Loading Facebook Comments ...
Loading Disqus Comments ...