How to Make a Graph on Google Sheets

Staring at a spreadsheet full of numbers can make your eyes glaze over, but a simple graph can instantly turn that data into a clear visual story. Transforming your raw data into a chart makes trends, comparisons, and outliers immediately obvious to anyone who sees it. This guide will walk you through exactly how to make a graph in Google Sheets, from creating your very first bar chart to customizing it for a polished, professional look.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First Things First: Prepare Your Data

Before you can make a great graph, you need data that's clean, organized, and easy for Google Sheets to understand. This is the single most important step. If your data is messy, your chart will be, too.

For best results, structure your data in simple columns and rows. Typically, your labels or categories will be in the first column, and the numbers you want to plot will be in the adjacent columns. Each column should have a clear header in the first row. Avoid empty rows or columns within your data set, as this can confuse the chart-making tool.

Here's a perfect example of a simple data set ready for graphing:

Notice how it's structured:

• Column A contains the text labels (Months).
• Column B contains the numerical values (Sales Revenue).
• Both columns have headers (Month and Sales Revenue).

With your data organized like this, you're ready to create your chart.

How to Make a Graph in Google Sheets: A Step-by-Step Guide

Once your data is properly formatted, creating a graph takes only a few clicks. Google Sheets does an excellent job of guessing what kind of chart you need and generating a preview instantly.

Step 1: Select Your Data

Click and drag your mouse to highlight all the cells you want to include in your graph, including the headers. In our example above, you would highlight cells A1 through B7.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Insert the Chart

With your data selected, navigate to the main menu at the top of the screen and click Insert > Chart.

Step 3: Meet the Chart Editor

Google Sheets will automatically insert a default chart (often a column or line chart) onto your worksheet and open the Chart editor pane on the right-hand side. This powerful menu is where you can change the chart type, customize its appearance, and fine-tune every detail.

That's it! You've officially made a graph. Now, let's explore how to choose the right kind of graph and make it look great.

Choosing the Right Type of Graph for Your Data

Google's default chart choice is usually a solid start, but you can often tell a better story by selecting a different type. In the Setup tab of the Chart editor, click the dropdown under "Chart type" to see all your options. Here are the most common chart types and when to use them.

Column or Bar Chart: To Compare Different Categories

This is your go-to for comparing values across distinct categories. Use it to answer questions like, "Which product sold the most?" or "How many users did each marketing channel bring in?"

• When to use it: Comparing sales by product, signups per channel, or revenue per country.

Line Chart: To Track Changes Over Time

A line chart is perfect for showing a trend or progression over a continuous period, like days, months, or years. It helps you quickly spot patterns, growth, and volatility.

• When to use it: Tracking monthly website traffic, daily sales numbers, or quarterly stock performance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Pie Chart: To Show Parts of a Whole

Use a pie chart when you want to show how individual components make up a total amount, always presented as percentages totaling 100%. A word of caution: pie charts become hard to read with more than five or six categories. For more complex breakdowns, a bar chart is often better.

• When to use it: Displaying the percentage of website traffic from different sources (Organic, Social, Direct) or the market share of your top competitors.

Scatter Plot: To Find Relationships Between Variables

A scatter plot is used to see if there's a correlation between two different sets of numerical data. Each dot on the graph represents a single data point with two values. By looking at the pattern of dots, you can see if the two variables move together.

• When to use it: Analyzing if ad spend correlates with revenue, or if there's a relationship between a student's hours studied and their exam score.

Making Your Graph Look Good: Customization Tips

A default chart gets the job done, but a well-customized chart is easier to read and looks far more professional. The Customize tab in the Chart editor is your control center for visual enhancements.

Here are the key things you can tweak:

• Chart & axis titles: This is a must. Give your chart a clear, descriptive headline. Label your vertical (Y-axis) and horizontal (X-axis) so everyone knows exactly what they're looking at.
• Series: Here, you can change the color of your bars, lines, or pie slices to match your brand or to highlight a specific data point. You can also add data labels to show specific values directly on the chart.
• Legend: If you have multiple data series (e.g., sales for Product A and Product B), the legend tells your viewer which color corresponds to which data. You can change its position (top, bottom, right) for better readability.
• Gridlines and Ticks: Under the Gridlines and Ticks section, you can add or remove the background lines on your chart. Sometimes, removing them can create a cleaner, more modern look.
• Font and Colors: In the Chart style section, you can change the background color, font, and chart border to better fit a presentation or report.

Take a few minutes to play around with these options. Small changes, like a clear title and branded colors, can transform a generic chart into a powerful communication tool.

A Few Pro-Tips to Level Up Your Google Sheets Graphs

Ready to move beyond the basics? Here are a few handy tricks for working with graphs in Google Sheets.

Add a Trendline

When using a line chart or scatter plot, you can add a trendline to help visualize the general direction of your data. In the Customize > Series section, simply check the "Trendline" box. It's a quick way to see if your sales are trending up or down over time, even with monthly fluctuations.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Use "Switch rows/columns"

Sometimes, Google Sheets misinterprets how your data is laid out. In the Setup tab of the Chart editor, there's a "Switch rows/columns" button. If your chart looks weird - like it's plotting months as values instead of labels - clicking this button often fixes it instantly.

Publish Your Chart to the Web

Need to share your chart with someone who doesn't have access to your Google Sheet? Click the three-dot menu in the upper-right corner of your chart and select Publish chart. You can get a public link or an embed code to add the chart directly to a website. The best part? It stays connected to your data and will update automatically if you change the numbers in your sheet.

Final Thoughts

Learning how to create graphs in Google Sheets turns your data into clear, actionable insights that are easy for anyone to understand. By mastering data setup, choosing the right chart type, and applying a few key customizations, you can build an informative and professional-looking chart in just a few minutes.

Building charts manually is a great skill, but the process can become a tedious daily or weekly chore when you're pulling reports from multiple platforms like Google Analytics, Shopify, Facebook Ads, and your CRM. We built Graphed to solve this a different way. We connect directly to all your data sources, letting you create dashboards and get answers in seconds by using an AI analyst that understands natural language. Just ask "create a graph of our revenue from Shopify vs Facebook Ads spend this quarter," and we serve up a real-time visualization, saving you from the never-ending task of exporting CSVs and wrestling with spreadsheets.