In this article, we will show you how to create and customize a Google Forms graph in Google Sheets. Simply follow the process below.
Follow the steps below to create a visual representation of your Google Forms data.
Navigate to your Google Form and click on the 'Responses' tab. Here, you'll find all the responses for your T-shirt size survey, categorized by size options like XS, S, M, L, and XL.
In the Responses tab, click on the Google Sheets icon (a green spreadsheet icon) to automatically transfer all your form data into a new Google Sheets document. This allows for a more versatile analysis and chart creation.
In Google Sheets, locate and select the columns or rows that contain the T-shirt sizes and the number of orders for each size. This precise selection is crucial for generating an accurate chart.
Go to the 'Insert' menu at the top of Google Sheets, then select 'Chart'.
In the chart editor that appears, choose a chart type—like a bar chart for comparison or a pie chart for percentage distribution—that best showcases your size data.
Follow the process below to personalize your charts in Google Sheets
In the Chart Editor on the right, under the 'Setup' tab, pick a chart type that aligns with your data presentation goals. For instance, a pie chart is excellent for showing proportions, while a bar chart is ideal for comparing different sizes.
In the 'Customize' tab of the Chart Editor, personalize your chart. Add a title, change the color scheme to distinguish different sizes easily, and adjust the font style and size for better readability.
If your chart has axes (like in a bar chart), label them for clarity. For example, label the horizontal axis with 'T-Shirt Sizes' and the vertical axis with 'Number of Orders' to inform viewers about what the chart represents.
Customize the chart's legend by adjusting its position and style in the 'Customize' tab. Ensure it's placed where it's easily visible and doesn't overlap with important chart details.
For direct insight into the data, add data labels displaying the specific number of orders for each T-shirt size. This can be done in the 'Customize' tab uder 'Chart & axis titles' or 'Series' depending on your chart type.
We hope that you now have a better understanding of how to create a Google Forms Graph and customize it in Google Sheets. If you enjoyed this article, you might also like our article on legally binding Google Forms or our article on how to undo in Google Forms. If you want to know how to get an email notification for each response in Google Forms, we also suggest checking out our detailed guide.