How to Make a Correlation Graph in Google Sheets

Discovering the relationship between two different business metrics, like how your ad spend affects sales or how customer support tickets impact churn rate, is fundamental to making smarter decisions. Creating a correlation graph is the perfect way to visualize these relationships, turning columns of numbers into a clear, actionable picture. This guide will walk you through exactly how to create a powerful correlation graph in Google Sheets, even if you’ve never made one before.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is Correlation, and Why Should You Visualize It?

In simple terms, correlation is a measure of how two variables move in relation to each other. When one variable changes, what does the other one do? A correlation graph - which is almost always a scatter plot - helps you see this relationship instantly.

There are typically three types of correlation you'll encounter:

• Positive Correlation: When one variable increases, the other variable also increases. Imagine your monthly ad spend and website traffic. As you spend more on ads, you typically expect traffic to go up. The data points on a graph would trend upward from left to right.
• Negative Correlation: When one variable increases, the other variable decreases. For example, as you increase employee training hours (the first variable), you might see the number of product defects (the second variable) go down. This trend would move downward from left to right on a graph.
• No Correlation (or Zero Correlation): There is no discernible relationship between the two variables. The number of rainy days in London and the revenue of your business in Chicago likely have no connection. The data points on a graph would look randomly scattered, with no clear upward or downward trend.

While you can calculate a correlation coefficient (a single number that represents the relationship), a graph is often more insightful. A scatter plot shows you not just the general trend but also the presence of outliers - data points that don't fit the pattern - and the overall strength of the relationship at a glance. Visualizing data makes patterns pop in a way that staring at raw numbers never will.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Preparing Your Data for a Correlation Graph

Before you can make a meaningful chart, your data needs to be structured properly. The good news is that for a correlation graph, the structure is incredibly simple. All you need are two columns of numerical data in your Google Sheet.

Here’s the key setup:

1. Have two columns, side by side. This is the most common format and makes it easy for Google Sheets to understand what you want to chart.
2. Each row should represent a single instance or time period. For example, each row could be a day, a week, a specific marketing campaign, or a customer.
3. Label your columns clearly. Use headers like "Ad Spend ($)" and "Daily Sales," or "Study Hours" and "Test Score."

It helps to know the difference between an independent and a dependent variable:

• The independent variable is the one you think might be causing a change. It's the factor you manipulate or observe. It goes on the X-axis (the horizontal axis).
• The dependent variable is the one that is being affected. It "depends" on the independent variable. It goes on the Y-axis (the vertical axis).

While you don't always need to get this perfect, a good rule of thumb is to place the "cause" in the left column and the "effect" in the right column.

Example Data Structure:

Imagine you run an e-commerce store and want to see if there's a connection between your daily ad spend on Facebook and your daily revenue. Your data might look like this:

For your graph, you would just use the "Ad Spend ($)" and "Revenue ($)" columns.

Step-by-Step: Creating a Scatter Plot in Google Sheets

Once your data is ready, creating the basic chart takes just a few clicks. Follow these steps:

1. Select your data. Click on the column header for your first variable (e.g., 'Ad Spend') and, while holding down the Shift key, click the header for your second variable (e.g., 'Revenue'). This will highlight both columns of data.
2. Insert the chart. Go to the menu bar at the top and click Insert > Chart.
3. Change the chart type. Google Sheets will likely try to guess what chart you want and may default to a line or bar chart. We need to change this. On the right-hand side of your screen, the Chart editor pane will appear. Under the "Setup" tab, find the "Chart type" dropdown menu.
4. Choose "Scatter chart." Click the "Chart type" dropdown, scroll down the list of options, and select Scatter chart.

That's it! You should now have a basic scatter plot on your screen, with each dot representing a row from your data (e.g., one day's ad spend and revenue).

Adding a Trendline to Your Graph

A scatter plot is useful, but to make the correlation truly obvious, you need to add a trendline. A trendline is a single line that best represents the direction and strength of the relationship in your data.

Here’s how to add one:

1. Double-click on your chart to re-open the Chart editor pane if it's not already open.
2. Click on the "Customize" tab in the editor.
3. Expand the "Series" section by clicking on it.
4. Scroll down a bit, and you will see a checkbox for "Trendline." Check this box.

A line will immediately appear on your chart. If it slopes upward, you have a positive correlation. If it slopes downward, you have a negative correlation. If it's mostly flat, you likely have no strong correlation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Calculate and Display R-squared

Just looking at a trendline gives you a good sense of the relationship, but how strong is it exactly? Is the correlation weak, moderate, or very strong? For this, we use a value called R-squared (R²).

R-squared is a statistical measure that represents the proportion of the variance for a dependent variable that is explained by an independent variable. In plain English, it's a number between 0 and 1 that tells you how well your trendline fits your data.

• An R-squared value of 0.9 means that 90% of the variation in your "Revenue" can be explained by the variation in your "Ad Spend," indicating a very strong relationship.
• An R-squared value of 0.2 means only 20% can be explained, indicating a weak relationship.

Displaying R² Directly on the Chart:

You can add this powerful metric to your chart directly from the Trendline options:

1. In the same "Customize" > "Series" section where you added the trendline, look for the "Label" dropdown menu just below it.
2. Click the dropdown and select "Use Equation" in order to see the full formula, or for a cleaner view select "Show R²." The R-squared value will now appear on your chart, usually in the legend.

Using the CORREL Formula in a Cell

If you prefer to have the correlation value in a cell rather than on the chart, you can use the CORREL function. This function gives you the correlation coefficient (often abbreviated as "r"), which ranges from -1 to +1.

Click on an empty cell and type the formula:

=CORREL(data_range_y, data_range_x)

Assuming your "Ad Spend" is in column B (from cell B2 to B11) and your "Revenue" is in column C (from cell C2 to C11), your formula would be:

=CORREL(C2:C11, B2:B11)

The result will be a number between -1 and 1. To get the R-squared value, you can simply square this result: =CORREL(C2:C11, B2:B11)^2.

Customizing and Interpreting Your Final Graph

A good chart isn't just mathematically correct - it's also easy to read and understand. Take a few final moments to polish your graph.

In the Chart editor's "Customize" tab, you can easily adjust:

• Chart & axis titles: Click on "Chart & axis titles" to give your graph a descriptive name like "Correlation of Ad Spend vs. Daily Revenue" and label your horizontal (X) and vertical (Y) axes.
• Series colors: Under the "Series" section, you can change the color and shape of your data points and the color and thickness of your trendline.
• Gridlines and Ticks: If your chart feels cluttered, you can adjust the gridlines to make it cleaner.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Finally Read the Graph:

Bring it all together to form a conclusion. With our ad spend example, if your final chart has:

• An upward-sloping trendline...
• Data points that are relatively close to that line...
• And an R-squared value of, say, 0.82...

You can confidently conclude: "There is a strong, positive correlation between our daily ad spend and revenue." This insight tells you that, generally, increasing your ad budget is a good strategy for growing sales.

If the R-squared was weak (e.g., 0.15) and the dots were scattered everywhere, your conclusion would be the opposite: "There is no significant correlation, and our ad spend does not appear to reliably predict daily revenue." This insight is just as valuable, as it tells you to investigate other factors that might be driving growth.

Final Thoughts

You've now learned how to transform raw column data into a clear and insightful correlation graph in Google Sheets. From properly structuring your data and creating a scatter plot to adding a quantitative trendline and interpreting the R-squared value, you have a complete toolkit for uncovering the hidden relationships in your business metrics.

While creating a single report in Google Sheets is powerful, we know that the real challenge often lies in connecting all your different data sources and keeping those reports updated automatically. That’s why we built Graphed. Instead of clicking through menus, you can just ask in plain English, “Show me the correlation between my Google Ads spend and our Shopify revenue for the last quarter,” and receive a live, interactive dashboard in seconds. Our goal is to let you skip the manual setup and get straight to the insights that help you grow your business.