How to Make an X Y Graph in Google Sheets with AI

An XY graph, also known as a scatter plot, is a fantastic way to see the relationship between two different sets of numbers. If you've ever wondered how your ad spend affects website traffic or how the number of sales calls impacts closed deals, an XY graph can give you a clear, visual answer. This article will walk you through exactly how to create a detailed XY graph in Google Sheets, including how to use its built-in AI tools to get the job done even faster.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is an XY Graph (and Why Should You Care)?

At its core, an XY graph uses dots to represent the values for two different variables. One variable's value determines the dot's horizontal position (the X-axis), and the other's value determines the vertical position (the Y-axis). When you plot a bunch of these dots, you can see patterns emerge that might otherwise be hidden in a spreadsheet of numbers.

These patterns help you understand the correlation between your two variables:

• Positive Correlation: As variable X increases, variable Y also tends to increase. The dots will generally trend upward from left to right. Example: The more you spend on ads, the more conversions you get.
• Negative Correlation: As variable X increases, variable Y tends to decrease. The dots will generally trend downward from left to right. Example: The higher the price of a product, the lower the number of units sold.
• No Correlation: There's no obvious relationship between the two variables. The dots are scattered randomly with no clear direction. Example: The number of posts on your company blog and your office's monthly electricity bill.

This is incredibly valuable for business. It helps you answer critical questions like:

• How does our marketing spend correlate with sales revenue?
• Is there a relationship between website page speed and bounce rate?
• Do sales reps who make more calls actually close more deals?

Step 1: Get Your Data Ready in Google Sheets

Before you can make a graph, you need to have clean, organized data. For an XY scatter plot, this is very simple. All you need are two columns of numerical data sitting side-by-side.

The first column will be your independent variable (X-axis). This is the variable you control or that you believe influences the other one. The second column will be your dependent variable (Y-axis), its value often “depends” on the independent variable.

Let's use a common marketing scenario. We want to see if our daily ad spend has a clear relationship with the number of newsletter signups we get each day. In this case:

• Independent Variable (X-axis): Daily Ad Spend ($)
• Dependent Variable (Y-axis): Daily Newsletter Signups

Your data in Google Sheets should look clean and simple, like this:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: How to Make an XY Graph in Google Sheets (The Manual Way)

Once your data is set up, creating the chart takes just a minute. Google Sheets makes the process straightforward.

1. Select Your Data

Click and drag your cursor to highlight both columns of data you want to visualize, including the header row.

2. Insert the Chart

With your data highlighted, go to the top menu and click Insert > Chart. A chart will instantly appear on your sheet, along with the Chart editor pane on the right side of your screen.

Google Sheets might try to guess what chart you want. Sometimes it gets it right, but often it will default to a Line Chart or Bar Chart. That's okay - we'll fix it in the next step.

3. Choose the "Scatter Chart" Type

In the Chart editor pane on the right, under the Setup tab, you'll see a section called Chart type. Click the dropdown menu and scroll down until you find the Scatter chart option. Select it.

Your chart will instantly transform into an XY scatter plot, with “Daily Ad Spend” on the X-axis and “Daily Newsletter Signups” on the Y-axis.

Step 3: Add a Trendline to Find the Pattern

The collection of dots on your chart gives you a general idea of the relationship, but adding a trendline makes the pattern much easier to see. A trendline is a single line that best fits the data, showing the general direction of the correlation.

1. Open the Chart Editor

If the Chart editor pane is not open, simply double-click on your chart to bring it back up.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Navigate to the Series Options

In the editor pane, click on the Customize tab. From there, click to expand the Series dropdown menu.

3. Add the Trendline

Scroll down within the Series options until you find a checkbox labeled Trendline. Click it.

A straight line will immediately appear on your graph. Because the dots in our example trend upwards, the trendline clearly shows a positive correlation. This instantly tells you that, generally, when you spend more on ads, you get more signups.

You can also customize the trendline's color, thickness, and type (Linear, Exponential, etc.). For most business data, Linear is the best choice.

Step 4: Use Google Sheets' AI to Build Your Graph Automatically

Building the chart manually is quick, but Google Sheets has a built-in AI tool called Explore that can do most of the work for you. It's designed for people who aren't data experts but need quick insights.

The Explore feature automatically analyzes your data and suggests charts, graphs, and summary statistics to you. You can even ask it questions using plain English.

1. Open the Explore Panel

First, select the same data you used before (your two columns for Ad Spend and Signups). Then, click the Explore icon in the bottom-right corner of your screen. It looks like a small square with a star in it. (You can also use the keyboard shortcut: Alt + Shift + X on Windows or Option + Shift + X on Mac).

2. Analyze the Suggested Charts

A new panel will open on the right, populated with automatically generated charts. Because your data has two numeric columns, Google Sheets is smart enough to know you're likely looking for a correlation. It will almost always suggest a Scatter Plot right away.

You can hover over the suggested chart to get a larger preview. If it looks correct, you can either drag and drop it directly onto your sheet or click the "Insert Chart" icon.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Ask for the Chart Using Natural Language

Here's where the AI really shines. At the top of the Explore panel is a text box where you can ask questions about your data. You don't need to learn special formulas or coding languages. You can simply type a request like:

“Scatter plot of Daily Ad Spend vs Daily Newsletter Signups”

Hit enter, and the Explore panel will generate the exact XY graph you need. You can try other phrases too, and it's surprisingly good at understanding what you want:

• “Correlation between ad spend and signups”
• “Plot signups against ad spend”

Bonus: Pro Tips for Making Your XY Graph Effective

Creating the graph is only half the battle. Presenting it clearly is what turns data into a decision. Here are a few simple best practices:

• Label Everything: Your graph should be understandable at a glance. Always make sure the chart title, X-axis, and Y-axis are clearly labeled. Google Sheets usually does this for you based on your column headers, but you can edit them in the Customize > Chart & axis titles section of the Chart editor.
• Don't Confuse Correlation with Causation: This is the most important rule of data analysis. Your XY plot might show a strong correlation between two variables, but it doesn't prove that one causes the other. For our example, higher ad spend correlates with more signups. This seems causal. But what if during a high-spend week, you also got featured in a popular newsletter? The newsletter could be the real cause of the signup spike, not just the ad spend. Always consider external factors.
• Keep it Simple: Resist the urge to add 3D effects, weird fonts, or distracting background colors. The goal is clarity. A simple, clean graph is far more effective at communicating your message.

Final Thoughts

Creating an XY graph in Google Sheets is a powerful skill that helps you visually confirm relationships hiding in your data. Whether you build it manually or use the AI-powered Explore feature to speed up the process, you can get valuable business insights in just a few clicks.

As you get comfortable with this, you'll find yourself creating these reports from more than just Google Sheets. Often, the real work is pulling data from advertising platforms, your CRM, and your e-commerce store just to get it all in one sheet to begin with. We built Graphed to remove that friction completely. Instead of exporting CSVs, you connect all your tools once, then ask in plain English - like "show the correlation between Facebook Ads CPC and Shopify conversion rate" - and instantly get a live, interactive dashboard that updates automatically.