How to Get Slope from Google Sheets Graph

Seeing an upward or downward trend in your Google Sheets chart is great, but "going up" isn't a precise metric. To truly understand the rate of change - how quickly your sales are growing, your costs are shrinking, or your ad conversions are climbing - you need to find the slope of that trendline. This article will show you two straightforward methods to calculate and interpret the slope directly within Google Sheets, transforming a simple graph into a meaningful analytical tool.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Slope (and Why Should You Care)?

Before jumping into the "how," let's quickly cover the "why." The slope is a single number that represents the steepness of a line. In data analysis, it tells you how much the dependent variable (the thing you're measuring, usually on the Y-axis) changes for every one-unit increase in the independent variable (often time or a factor you control, on the X-axis).

In business terms, this translates to tangible insights:

• Sales Growth: A slope of 500 in a sales-over-time chart means you're gaining an average of $500 in sales each month.
• Marketing ROI: A slope of 4.5 in a conversions-vs-ad-spend chart means you get 4.5 conversions for every additional dollar you spend.
• User Churn: A slope of -20 in a subscribed-users-over-time chart means you're losing an average of 20 users each week.

The slope turns a vague observation ("our numbers are going up") into a quantifiable rate of change that you can use for forecasting, goal setting, and strategic decision-making.

Method 1: The Visual Approach (Adding a Trendline to a Chart)

This is the most common way to find the slope, as it also provides a helpful visual reference. It’s perfect when you're preparing a report or presentation and want to show the trend alongside your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Prepare Your Data

First, you need two columns of data that you believe have a relationship. Your X-axis data (independent variable) should be in the left column, and your Y-axis data (dependent variable) should be in the right column.

Let's use a simple example of tracking monthly revenue for the first six months of the year.

In column A ("Month"): 1, 2, 3, 4, 5, 6 In column B ("Revenue"): $2,300, $2,900, $3,400, $4,100, $4,500, $5,200

Step 2: Create a Scatter Plot

A line chart can work, but a scatter plot (also called a scatter chart) is technically the best choice for visualizing the relationship between two different variables and fitting a trendline to them.

1. Highlight your data, including the headers (cells A1 through B7 in our example).
2. Go to the menu and click Insert > Chart.
3. Google Sheets will often default to a line chart or bar chart. In the Chart editor panel on the right, under the "Setup" tab, find the "Chart type" dropdown and select Scatter chart.

You should now see a chart with dots representing your monthly revenue data points.

Step 3: Add and Customize the Trendline

Now we’ll add the trendline, which is a straight line that best represents the overall direction of your data points.

1. In the Chart editor, click on the Customize tab.
2. Click to expand the Series section.
3. Scroll down and check the box for Trendline. A line will immediately appear on your chart.
4. You can customize the line's color, thickness, and type (Linear is the default and correct for calculating a simple slope).

Step 4: Display the Equation of the Line

This is where the magic happens. The equation of that trendline contains the slope we're looking for.

1. While still in the Series customization options, scroll down further to the "Label" dropdown menu.
2. Click on the dropdown (it’s set to "None" by default) and choose Use Equation.
3. Optionally, but recommended, also check the box for Show R² just below it. We’ll discuss what this means later.

The equation will now be displayed on your chart, typically looking something like this: y = 574.3x + 1683.3.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 5: Identify the Slope from the Equation

It's time to remember a little bit of high school algebra! The standard equation for a straight line is y = mx + b.

• y is your dependent variable (Revenue)
• x is your independent variable (Month)
• b is the y-intercept, where the line would cross the y-axis if x were 0.
• m is the slope - the number you're looking for.

In our example equation, y = 574.3x + 1683.3, the number multiplying 'x' is 574.3.

Therefore, the slope is 574.3.

What does this mean for our business? It means that, on average, our revenue is increasing by $574.30 each month.

Method 2: The Formula Approach (Using the SLOPE Function)

The visual approach is fantastic for presentations, but what if you just need the number quickly without creating a chart? Google Sheets has dedicated functions for this: SLOPE and INTERCEPT.

The SLOPE function is fast, direct, and perfect for dashboards where you just want to feature a key metric without the clutter of a graph.

How to Use the SLOPE Function

The syntax for the function is:

=SLOPE(data_y, data_x)

A common mistake is getting the X and Y ranges mixed up. Remember that the dependent variable (your Y-axis data) goes first.

1. Click on an empty cell where you want the slope to appear.
2. Type the formula. Using our revenue example, the "Revenue" column (B2:B7) is our data_y, and the "Month" column (A2:A7) is our data_x.
3. The formula will look like this:

=SLOPE(B2:B7, A2:A7)

When you press enter, the cell will instantly return the value 574.29 (rounding slightly differently than the chart label, but essentially the same number).

Bonus: Finding the Intercept

You can also find the "b" part of the equation (the y-intercept) using the sister function, INTERCEPT.

=INTERCEPT(B2:B7, A2:A7)

This gives you a complete forecasting tool. You can now use these calculated values to predict future revenue. For example, to predict revenue for month 8, the formula would be: (slope * 8) + intercept or (574.3 * 8) + 1683.3.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding R-squared: How Reliable is Your Trendline?

Remember that "Show R²" box we checked? The R² value, also called the "coefficient of determination," is a score between 0 and 1 that tells you how well the trendline fits your data. It answers the question, "How much of the variation in my Y-axis data can be explained by the X-axis data?"

• An R² close to 1 (e.g., 0.98) means your data points are very close to the trendline. The relationship is strong and predictable. Our example had a high R² of 0.983, indicating that time is a very good predictor of revenue in this dataset.
• An R² close to 0 (e.g., 0.15) means your data points are widely scattered far from the line. There isn't a strong linear relationship. For instance, if you charted revenue vs. the number of rainy days, you might get a very low R².

Looking at R² is a critical step. A steep slope might seem exciting, but if the R² value is low, that trend isn't very reliable and your forecasts based on it will likely be inaccurate.

Final Thoughts

Calculating the slope in Google Sheets gives you a powerful and precise number to measure momentum. Whether you prefer the visual method of adding a trendline and displaying its equation or the quick formulaic approach with SLOPE(), you can now move beyond gut feelings and use hard data to describe and forecast trends in your business.

While mastering spreadsheets is incredibly valuable, juggling manual reports across different platforms can drain your time and energy. We built Graphed to solve this problem. Instead of exporting CSVs and recreating trendlines manually, you can connect your data sources (like Google Analytics, Shopify, and your ad platforms) in a few clicks. Then, just ask in plain English, "show me a dashboard of a monthly revenue trend from Shopify," and we build it for you instantly with live, updating data. That way, you're always focused on the insights, not on the process of finding them.