Google Sheets Chart Trendlines: Add and Interpret One

To add a trendline in Google Sheets, open the chart editor, choose Customize > Series, select the data series, and turn on Trendline. You can then choose a model and, if useful, display its equation or R-squared value to summarize the pattern in the data.

How to add a trendline in Google Sheets

First, arrange the data so the chart can identify the values to compare. For a simple relationship, put the independent variable—such as time, distance, or advertising spend—in one column and the measured value in the next. Select the data range, then choose Insert > Chart. In the Chart editor’s Setup tab, select a suitable chart type if Sheets did not choose one automatically.

Click the chart to open the Chart editor. If the editor is closed, double-click the chart.
Open Customize > Series.
Use the series selector to choose the data series you want to analyze. If there is only one series, it is usually selected already.
Check Trendline, then use the options below it to choose the trendline type, label, and appearance.
To display a fit statistic, turn on Show R², where that option is available.

The chart updates as you change the settings. A trendline is attached to a series, not simply to the whole chart, so a chart with several series may need a separate selection for each one. The feature is available for supported chart types, including scatter, line, column, and bar charts. If the Trendline control is missing, check the chart type and the selected series before assuming the data is unsuitable.

Choose a chart and prepare the data

A scatter chart is often the clearest choice when you want to study how one numeric variable changes with another. It positions each observation according to its x- and y-values, which makes the relationship visible and gives the trendline a meaningful numeric horizontal axis. A line chart is a natural fit for measurements collected over time, particularly when the order of observations matters. Column and bar charts can also support trendlines, but categorical labels may make a fitted line harder to interpret as a continuous relationship.

Before adding the line, check that the chart is using the intended columns and that the first row is treated as a header when appropriate. In the Chart editor’s Setup tab, inspect the data range, X-axis, and Series fields. Each row should represent a comparable observation. For example, a table of monthly website visits should use months in chronological order and one visit total per month, rather than mixing monthly totals with daily values.

Use consistent units throughout a series; do not mix dollars with thousands of dollars.
Check for blank cells, text values in numeric columns, and accidental totals included as observations.
For a scatter chart, ensure the intended numeric column is assigned to the X-axis rather than treated as another series.
Keep outliers in the data unless there is a documented reason to correct or exclude them; an unusual value can substantially affect a fitted line.

Trendline types and when to use them

Google Sheets offers several trendline models. The right choice depends on the shape you are trying to summarize and on whether the model makes sense for the subject. Changing the type just to make the line follow every point more closely can make the chart less informative.

Linear: A straight line that represents a roughly constant increase or decrease. Its equation is commonly written y = mx + b, where m is the slope and b is the intercept.
Exponential: A curved model for a pattern that changes at a rate related to its current level, such as some forms of growth or decay. It is not appropriate for every curved series, and its use depends on the data meeting the model’s requirements.
Polynomial: A curve that can bend to represent changes in direction. The selected degree controls its complexity; a higher-degree curve can follow the observed points closely but may be a poor guide to future values.
Logarithmic: A model that can describe a rapid initial change followed by slower change. It is useful only when the variables and data shape support that interpretation.
Power series: A model in which one variable changes as a power of another. It can suit some scaling relationships, but should not be selected merely because it produces a visually appealing curve.

When the underlying relationship is uncertain, start with a scatter chart and a linear trendline. Then compare other plausible models and examine the plotted data, the equation, and the subject-matter context together. Some nonlinear models require positive values or otherwise have domain restrictions; if Sheets cannot fit a chosen type, verify that the x- and y-values are numeric and compatible with that model.

Read the equation and R-squared carefully

Selecting a trendline label can show the fitted equation on the chart. For a linear line, the slope describes the estimated change in y for a one-unit increase in x. If a chart compares weekly study hours with a test score, for example, a slope of 3 would mean that the fitted line rises by three score units per additional hour in the units shown. It does not prove that studying caused that increase; other factors may affect the observed scores.

R-squared, often written as R², summarizes how much of the variation in the observed values is accounted for by the fitted model in the data used to fit it. A value closer to 1 usually indicates a closer in-sample fit, while a lower value indicates that the model leaves more variation unexplained. It is not a probability that the model is correct, a measure of causation, or a guarantee that the line will predict future observations accurately.

Use R² with care when comparing models. A more flexible curve can fit the data more closely simply because it has more freedom to bend. A high value may also be misleading when the sample is small, observations are not independent, or one outlier dominates the pattern. Look at the scatter of points, the plausibility of the model, and whether the fit remains useful for the question you are asking—not only at the displayed statistic.

A practical example: monthly sales

Suppose a small shop records monthly advertising spend and sales. A scatter chart can place spend on the horizontal axis and sales on the vertical axis. A linear trendline can show whether higher spending tends to coincide with higher sales across the recorded months. If the line slopes upward, that is evidence of a positive association in this dataset, but it does not establish that advertising alone produced the increase. Seasonality, promotions, pricing, and changes in customer demand could also matter.

For a different question, the shop might chart monthly sales against month number to show the passage of time. A line chart can make a long-term direction visible, but sales may rise and fall with holidays or seasonal cycles. A straight trendline compresses those ups and downs into one average direction. It can therefore be useful for orientation while obscuring recurring variation. If the intended question concerns seasonality, display enough years to compare the same months and do not treat a single overall trendline as a seasonal analysis.

In either version, use the axis labels and units to make the chart self-explanatory. Label the horizontal axis as advertising spend in dollars or month number, for example, rather than leaving readers to infer the scale. If you show an equation or R², place it where it does not cover important points and explain what the variables represent in the chart’s context.

Common problems and fixes

If the checkbox does not appear, confirm that you are in Customize > Series, not the Setup tab, and that the chart type supports trendlines. With multiple series, select the intended series in the selector. A series with text or missing numeric values may not behave as expected; check the source range and the chart’s axis assignments.

If the line looks unrelated to the points, review the X-axis. A chart that treats dates or category labels as text may arrange values differently from a numeric scatter chart. Also inspect whether the chart includes a total row, an empty row, or an unintended column. Changing the chart type can clarify the relationship, but verify that the change does not alter which fields are being plotted.

If the equation or R² is hard to read, adjust the trendline label and chart layout in the editor, or widen the chart. Avoid placing a label over a cluster of important observations. For a polynomial line that swings sharply at the ends, try a simpler model and consider whether there are enough observations to justify the extra curvature. A visually smooth line is not automatically a better explanation.

Trendlines, forecasts, and other ways to show a pattern

A trendline is a fitted curve or line displayed over chart data. It is not the same thing as a forecast, which estimates values beyond the observations and requires assumptions about what will continue. Extending a trendline mentally—or using its equation outside the range of the data—can produce implausible results. Extrapolation is especially risky when the data covers a short period or the process changes over time.

For readers who need to see each observation, keep the points visible rather than replacing them with a line alone. For a time series with strong short-term fluctuations, a separate summary or smoothing approach may communicate the pattern better than a single fitted model. A pivot table, a carefully chosen chart, or a dedicated forecasting method may be more suitable when the goal is to compare groups, account for seasonality, or make operational predictions. Excel also has chart trendlines, but its interface and available options can differ; the menu path in this article is for Google Sheets in a web browser.

Frequently Asked Questions

Why can’t I add a trendline in Google Sheets?
Open Customize > Series in the Chart editor and select the series you want. If the option is still unavailable, check that the chart uses a supported type, such as scatter, line, column, or bar, and that the plotted series contains usable numeric data.

Can I add a trendline to only one series?
Yes. In Customize > Series, choose a series from the selector and enable its Trendline setting. Repeat the process for another series only if you want a separate fitted line for it.

What does R² mean on a Google Sheets chart?
R² describes how closely the selected model fits the observations used to create it. A higher value can indicate a closer fit in that dataset, but it does not establish causation or guarantee accurate forecasts.

Can a Google Sheets trendline predict future values?
A trendline summarizes a fitted relationship in the chart; it should not be treated as a reliable forecast by itself. Predictions beyond the observed range are extrapolations and can fail when the pattern changes or important factors are missing.

How do I show a trendline equation?
After enabling Trendline under Customize > Series, use the trendline’s label setting and choose the equation option. The equation’s meaning depends on the selected model and the units on the chart axes.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.