How to Get a Trend Line in Google Sheets

Staring at a line chart in Google Sheets can sometimes feel like looking at a mountain range. It goes up, it goes down, it zigs, it zags - but what's the overall direction? Is your website traffic slowly climbing despite weekly dips, or are your sales actually flat when you account for that one big launch month? A trend line cuts through this noise to give you a clear answer. This guide will walk you through exactly how to add, customize, and interpret trend lines in Google Sheets to find the real story hidden in your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Trend Line?

Think of a trend line as the simple, straightforward path through a complicated set of data points. It's a line added to a chart that shows the general direction or pattern in your data over time, smoothing out the minor fluctuations. Instead of getting lost in the day-to-day or week-to-week volatility, a trend line reveals whether the underlying movement is heading up, down, or staying level.

This is incredibly useful for a few reasons:

• Spotting Long-Term Patterns: Easily see if your sales, user engagement, or ad performance is improving over the long haul.
• Making Informed Forecasts: A trend line can help you make educated guesses about future performance based on past patterns.
• Communicating Insights Clearly: It’s much easier to show your team or clients "we're on an upward trend" with a visual line than by pointing at a dozen different noisy data points.

How to Add a Trend Line in Google Sheets (The Step-by-Step Guide)

Adding a trend line is surprisingly simple. Let’s walk through it with a common example: tracking monthly website sessions. All you need is two columns of data to get started.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Get Your Data Ready

First, make sure your data is organized in two columns. For our example, Column A will be the "Month" and Column B will be the "Website Sessions" for that month. Your sheet should look something like this:

Example Data

Month, Website Sessions Jan, 8500 Feb, 9200 Mar, 8900 Apr, 10500 May, 11200 Jun, 10800 Jul, 12500 Aug, 13100

Step 2: Create a Chart

Now, let's turn that raw data into a visual chart.

1. Click and drag to select all the data you want to plot, including the headers (e.g., cell A1 through B9).
2. Go to the top menu and click Insert > Chart.

Google Sheets will automatically analyze your data and suggest a chart type. For this kind of data, it will likely recommend a Line chart or Scatter chart. Both work perfectly for adding a trend line. If it suggests something else, you can easily change it in the Chart editor pane that appears on the right under the "Setup" tab.

Step 3: Add the Trend Line

Here’s where the magic happens. Once your chart is created and displayed on your sheet, follow these steps:

1. Double-click on the chart itself. This will reopen the Chart editor on the right side of your screen.
2. In the editor, click on the Customize tab.
3. Scroll down and find the Series dropdown menu. Click it to expand the options.
4. Scroll down within the "Series" options until you see a checkbox labeled Trendline. Check that box.

That's it! A dotted trend line will instantly appear overlaid on your data, showing you the general direction of your website sessions over the past eight months. In our example, you’ll see a clear upward sloping line, letting you know that despite some bumpy months, overall traffic is growing steadily.

Customizing and Understanding Your Trend Line

Just adding the line is a great start, but Google Sheets gives you more tools to get deeper insights. In that same "Trendline" section of the Chart editor, you'll see several options to customize and interpret your trend.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choose the Right Trend Line Type

Google defaults to a "Linear" trend line, which is a simple straight line. This is often all you need, but other types can tell a different story:

• Linear: Best for data that is increasing or decreasing at a relatively steady rate. Think of consistent month-over-month growth.
• Exponential: Use this for data that is growing at an accelerating rate (e.g., the curve gets steeper over time). This is great for tracking things like viral campaign performance or compound growth.
• Polynomial: This is a more flexible curved line that can have ups and downs. It's useful for datasets with a couple of peaks and valleys, like analyzing sales across different seasons in a year. Be careful, as it can sometimes overcomplicate the visual.
• Moving Average: This isn't a single line but a series of averages calculated from subsets of your full data set. It's excellent for smoothing out significant volatility to see the underlying trend more clearly. A 3-period moving average, for example, would average the data for the current period and the two prior periods.

Check the "Goodness of Fit" with R² (R-Squared)

This sounds technical, but the concept is simple. The R-squared (R²) value is a score from 0 to 1 that tells you how well the trend line actually fits your data. You can display it directly on your chart by checking the "Show R²" box.

• An R² value close to 1 means your data points are very close to the trend line. This indicates a strong, reliable correlation.
• An R² value close to 0 means your data is scattered widely around the line, so the trend isn't a very reliable predictor of the data.

As a rule of thumb, an R² above 0.70 is generally considered a strong fit. It gives you confidence that the trend you’re seeing is real and not just random chance.

Display the Equation for Forecasting

If you check the box for "Use Equation" under the "Label" dropdown, Google Sheets will display the mathematical equation for your trend line on the chart. While it might look intimidating if it's been a while since your last math class, its main purpose here is forecasting.

For a simple linear trend line, the equation looks like y = mx + b. You can plug in a future "x" value (like the next month in your series) to predict a future "y" value (your forecasted website sessions).

Graphed

Still Building Reports Manually?

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

Watch the Demo

Practical Example: Analyzing Ad Spend vs. Conversions

Let's tie this all together. Imagine you're running a marketing campaign and want to know if your ad spend is actually leading to more conversions. You have the daily spend in one column and daily conversions in another.

1. Select your data and create a Scatter chart (Insert > Chart). A scatter chart is perfect for seeing the relationship between two different variables.
2. Follow the steps to add a trend line. Double-click the chart, go to Customize > Series, and check "Trendline".
3. Check the "Show R²" box. This is crucial. Now you can analyze the result.

If you see an upward-sloping trend line with an R² of, say, 0.82, you can confidently say: "There is a strong, positive correlation between our ad spend and conversions. As we spend more, we consistently get more conversions." This simple chart and trend line provide a powerful, data-backed insight to justify your marketing budget.

Final Thoughts

Adding a trend line in Google Sheets is a simple but powerful technique to elevate your data analysis. It helps you move past the noisy, day-to-day fluctuations to quickly identify meaningful long-term patterns, spot relationships between variables, and make more confident, data-driven decisions.

While Google Sheets is fantastic for this kind of quick analysis, the process of constantly exporting CSVs, formatting data, and rebuilding charts across all your different platforms can become a huge time sink. We experienced this frustration ourselves, which is why we built Graphed. It connects directly to all your marketing and sales tools like Google Analytics, Shopify, and Facebook Ads, so instead of manually building charts, you can simply ask for the insight you need in plain English - like, “Show me a chart of my website sessions from Google Analytics trended over the last six months.” You get a real-time answer without ever opening a spreadsheet.