How to make a Graph in Google Sheets

Sanskar Tiwari

Author: Sanskar Tiwari

Founder at MagicSlides

Published

Learn how to create clear, professional graphs in Google Sheets with this simple step-by-step guide

Graphs make data visually appealing and easier to understand, especially when dealing with large sets of numbers.
Google Sheets, a free cloud-based spreadsheet tool, makes it super easy to create different types of graphs like bar charts, line charts, and pie charts.
Whether you're a student, marketer, or business analyst, this tutorial will help you turn raw data into insightful visuals in just a few steps no experience needed!

How to Make a Graph in Google Sheets | Step-by-Step Tutorial

Step 1: Open Google Sheets

notion image
  • Open a blank spreadsheet or the file with the data you want to graph.

Step 2: Enter or Select Your Data

  • Input your data in columns. For example:
    • Highlight the data range you want to graph, including headers.
    notion image

    Tired of spending hours cleaning data or writing complex formulas? Here’s a smarter solution: SheetAI.app

    Whether you're managing sales reports, crafting marketing content, or analyzing feedback, working in spreadsheets can be time-consuming and repetitive. But what if you could automate these tasks and enhance your productivity directly within Google Sheets? That's exactly what SheetAI offers.
    notion image
    SheetAI is an AI-powered add-on for Google Sheets that brings advanced capabilities right into your spreadsheet. Simply describe what you want in plain English, and SheetAI will execute tasks such as generating formulas, cleaning data, summarizing text, and even creating images. (SheetAI Documentation - AI-Powered Functions for Google Sheets)
    Here’s what you’ll love about SheetAI:
    • Natural Language Commands: Use plain English to perform complex tasks.
    • AI-Powered Functions: Leverage functions like =SHEETAI() and =SHEETAI_RANGE() for dynamic content generation.
    • Data Cleaning & Analysis: Automate data sanitization, summarization, and categorization.
    • Content Generation: Create blog ideas, product descriptions, and personalized messages effortlessly.
    • Image Creation: Generate images directly within your spreadsheet using =SHEETAI_IMAGE().
    • Formula Generation: Convert textual descriptions into accurate Google Sheets formulas.
    • Integration with AI Models: Supports GPT-3, GPT-4, Claude, and Gemini for versatile AI capabilities.
    Perfect for marketers, analysts, educators, and anyone looking to enhance their spreadsheet workflows.
    Ready to revolutionize your Google Sheets experience? Install SheetAI now and start automating your tasks with AI!

    Step 3: Insert a Chart

    • Click on the “Insert” menu at the top.
    notion image
    • Choose “Chart” from the dropdown menu.
    • Google Sheets will automatically suggest a chart type based on your data.

    Step 4: Customize Your Graph

    • A Chart Editor sidebar will appear on the right.
    • In the "Setup" tab, you can:
      • Change the chart type (e.g., Bar, Line, Pie).
      • Modify data range or labels.
        • notion image
    • In the "Customize" tab, you can:
      • Edit chart titles.
      • Change axis labels.
      • Adjust colors and fonts for better design.

    Step 5: Move or Resize the Graph

    • Click and drag the graph to reposition it within the sheet.
    • Drag the corners to resize it.

    Step 6: Save or Share Your Graph

    • Your graph auto-saves in Google Sheets.
    • To share, click the “Share” button in the top-right and set permissions.
    • To download, click on the graph → three-dot menu → “Download as image”.

    Conclusion

    Creating a graph in Google Sheets is a quick way to transform raw data into visual insights.
    With a few clicks, you can create, customize, and share compelling charts that help your audience understand your message at a glance. Practice with different chart types to see what best fits your data.

    FAQs are here to help!

    Can I create a graph from multiple sheets in Google Sheets?

    Yes, but you need to reference the data from the other sheet using formulas and bring it into one sheet before graphing.

    What types of graphs can I create in Google Sheets?

    Google Sheets supports bar charts, column charts, line charts, pie charts, area charts, scatter plots, and more.

    How do I change the graph type after inserting it?

    Click on the graph → Chart Editor → Setup tab → Choose a new chart type from the dropdown menu.

    Can I make dynamic graphs in Google Sheets?

    Yes, using functions like FILTER, QUERY, or using slicers and checkboxes, you can create interactive and dynamic charts.

    Share on socials