How to Make an X Y Graph

An XY graph, often called a scatter plot, is one of the most powerful and straightforward ways to see the relationship between two different variables. It helps turn rows of spreadsheet data into a clear picture that shows how one thing affects another. This article will walk you through what an XY graph is, why it's so useful, and how to create one step-by-step in common tools like Excel and Google Sheets.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is an XY Graph?

At its core, an XY graph (or scatter plot) visualizes the connection between two sets of numerical data. It uses a two-dimensional space defined by two axes: a horizontal x-axis and a vertical y-axis. Here’s a simple breakdown:

• The X-axis (Horizontal): This represents your independent variable. It's the factor you think might be causing a change or the one you feel you have more control over.
• The Y-axis (Vertical): This represents your dependent variable. Its value is thought to be influenced by, or dependent on, the x-axis variable.

Each point plotted on the graph represents a single observation with a specific X value and a corresponding Y value. When you plot many of these points together, you can start to see patterns emerge. For example, if you were a marketer tracking campaign performance, your x-axis might be "Daily Ad Spend," and your y-axis could be "Website Signups." A single dot would represent a specific day where you spent $100 (its X value) and got 15 signups (its Y value).

Why Should You Use an XY Graph?

XY graphs aren't just for statisticians, they're incredibly practical for marketers, salespeople, and business owners. They excel at telling a story that raw numbers can't, primarily by illustrating relationships and trends.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. To Spot Relationships (Correlation)

The most common use of an XY graph is to determine if a relationship, or correlation, exists between your two variables. These relationships generally fall into one of three categories:

• Positive Correlation: As the X value increases, the Y value also tends to increase. The points on the graph will trend upward from left to right. Business Example: Plotting employee training hours (X) against their customer satisfaction scores (Y). You'd hope to see that more training leads to higher satisfaction.
• Negative Correlation: As the X value increases, the Y value tends to decrease. The points will trend downward from left to right. Business Example: Plotting seasonal temperature (X) against sales of winter coats (Y). As the weather gets warmer, coat sales go down.
• No Correlation: There is no discernible pattern. The points are scattered randomly across the graph. This is also an important insight, as it tells you the two variables don't significantly influence each other. Business Example: Plotting the daily price of coffee (X) against the number of support tickets your software company receives (Y). You'd likely find no relationship.

2. To Identify Outliers and Clusters

An XY graph instantly highlights data that doesn’t fit the pattern. A point that is far away from the main group of points is called an outlier. This is often the most interesting data to investigate. Why did that one metric spike or plummet on a particular day? What made that one ad campaign so different from the rest?

Similarly, you might notice that data points form distinct clusters. This could indicate that different subgroups exist within your data. For example, plotting customer age versus purchase value might reveal that younger and older customers cluster around different spending habits.

3. To See the Strength of the Relationship

How closely do your data points follow a straight line? If they are very tightly packed around a line, it indicates a strong relationship. If they are loosely scattered but still show a general direction, it's a weaker relationship. This helps you understand how much you can rely on one variable to predict the other.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Build: Preparing Your Data

A great chart starts with well-organized data. Before you open Excel or Google Sheets, make sure your data is structured in two clean columns. One column will be for your x-axis data and the other for your y-axis data. It's vital that each row represents a single paired observation.

Let's say you're a content creator looking to see if there's a relationship between the length of your articles and the average time people spend reading them. Your spreadsheet should look like this:

• Column A (X-axis): Article Word Count (Independent Variable)
• Column B (Y-axis): Average Time on Page [in seconds] (Dependent Variable)

Your table would be simple:

With this simple layout, you're ready to create your graph.

How to Make an XY Graph in Excel

Excel is a classic tool for building scatter plots. The process is straightforward once you know where to click.

1. Enter Your Data: Input your independent (X) data in one column and your dependent (Y) data in the adjacent column, just like the example above.
2. Select Your Data: Click and drag your mouse to highlight both columns of data, including the headers.
3. Insert the Chart: Go to the Insert tab on the top ribbon. In the Charts section, look for an icon that looks like a plot of dots. This is the Insert Scatter (X, Y) or Bubble Chart option.
4. Choose Your Chart Type: Click the scatter plot icon. You'll see several options. The simplest and most common choice is the first one, just labeled Scatter. Clicking it will instantly generate your graph on the worksheet.
5. Customize and Improve: Your chart is created, but it's not finished. A good chart tells a clear story.

How to Make an XY Graph in Google Sheets

The process in Google Sheets is very similar to Excel, with slight differences in the user interface.

1. Enter Your Data: Just like in Excel, set up your two columns for X and Y variables.
2. Highlight Your Data: Select the cells containing your data, including the headers.
3. Insert the Chart: Go to the menu bar at the top and click Insert > Chart.
4. Select the Chart Type: Google Sheets is pretty smart and will often default to a scatter chart if your data fits. If it doesn't, a Chart editor sidebar will appear. Under the Setup tab, find the "Chart type" dropdown and scroll down to select Scatter chart.
5. Customize It: Use the Chart editor sidebar to refine your graph.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Making XY Graphs in BI and Reporting Tools

While spreadsheets are great for quick, one-off analyses, Business Intelligence platforms like Power BI, Tableau, or Looker elevate your graphing capabilities. Instead of manually entering data, these tools connect directly to your data sources (like Google Analytics, Salesforce, or Shopify).

The core concept is the same: you choose an X variable and a Y variable. However, the advantage is scale and automation. You can analyze thousands or millions of data points without crashing a spreadsheet. Better yet, the graphs are built on live data, so your charts are always up-to-date without any manual exporting or pasting.

Final Thoughts

Creating an XY graph is a fundamental skill for anyone working with data. It’s a fast and effective way to move beyond simple spreadsheets and start visually discovering the relationships, trends, and outliers that drive your business. Whether you use Excel for a quick look or dive a bit deeper with Google Sheets, you’re just a few clicks away from turning numbers into valuable insights.

While these tools are fantastic, the process of pulling data, cleaning it up in spreadsheets, and building charts can still eat up a lot of time, especially with live data from marketing and sales platforms. This is why we built Graphed to streamline everything. You just connect your apps a single time, then ask for what you need in plain English. Something as simple as, "Create an XY graph of my Facebook ad cost versus new monthly subscriptions from Stripe," instantly generates a live, interactive chart for you in seconds, saving you from the manual work and getting you straight to your answer.