In this article:

Google Forms Graph: How to Create one in 2024

In this article, we will show you how to create and customize a Google Forms graph in Google Sheets. Simply follow the process below. 

Creating a Graph from Google Forms Data

Follow the steps below to create a visual representation of your Google Forms data. 

1. Access Survey Data in Google Form's 'Responses' Tab

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.

google forms graph

2. Export Data to Google Sheets for Advanced Analysis

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.

3. Highlight Relevant Data in Sheets for Chart Preparation

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.

4. Insert a Chart in Sheets that Best Fits Your Data

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.

Customizing Graph in Google Sheets

Follow the process below to personalize your charts in Google Sheets

1. Choose the Most Suitable Chart Type in Chart Editor

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.

2. Style Your Chart with Custom Colors, Titles, and Fonts

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.

3. Add Clear Labels to Chart Axes 

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.

graph in google forms

4. Tailor the Legend for Clearer Data Understanding

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.

5. Include Data Labels for Direct Number Display

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. 

Get Google Forms productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->