What Does a Trendline Tell You in Excel? A Clear Guide

A trendline in Excel summarizes the general direction or pattern of data in a chart: it can show whether values tend to rise, fall, stay level, or follow a curved pattern. It is a statistical fit to the data you selected, not proof of why the values changed or a guarantee of what will happen next.

What a trendline shows

A trendline is a line or curve drawn through a chart’s data points to make the underlying pattern easier to see. Individual observations may sit above or below it, but the fitted line describes the overall relationship between the values plotted on the horizontal and vertical axes. For example, if a chart compares advertising spend with weekly sales, a rising trendline indicates that higher spend is associated with higher sales in the displayed data.

The line’s shape gives a quick visual summary. A straight line suggests a roughly constant rate of change; a curve may suggest that the rate changes as values grow. A flat line indicates little overall change across the plotted range. These are descriptions of the charted data, not explanations of causes. A trendline cannot establish that one variable caused another, and it may conceal important variation among the individual points.

Excel calculates the trendline from the data series you choose. If a chart has several series, each can have a different pattern, so adding a line to one series does not describe every series in the chart. Check which points the trendline is attached to before interpreting it.

How to add one in Excel

In Excel for Microsoft 365 on Windows, first create a chart containing the data you want to examine. Select the chart, then use Chart Design > Add Chart Element > Trendline and choose a type, such as Linear. For more settings, choose Chart Design > Add Chart Element > Trendline > More Trendline Options. The Format Trendline pane lets you select a model, set options such as a forecast, and, where supported, display the equation or R-squared value.

Arrange the data so each observation has an appropriate horizontal value and a corresponding vertical value. For numeric pairs, an XY (Scatter) chart is often a good starting point.
Insert a chart from the Insert tab, then select the chart and the data series that should receive a trendline.
Choose a trendline type that makes sense for the relationship, rather than selecting one only because it looks like a close fit.
Review the result against the plotted points, axis labels, and any displayed statistics. Remove the trendline if it makes the chart more confusing or implies more certainty than the data supports.

On Excel for Mac, the chart-design tools are also available from the chart-related ribbon, though the exact placement can vary with the version and window layout. Excel for the web may not offer all the same chart-formatting options as the desktop app. If you cannot find a particular setting, open the workbook in the desktop version of Excel.

How to read the line, equation, and R-squared

Start with the direction and steepness of the line. A line that slopes upward means the fitted values increase as the horizontal values increase; a downward slope means they decrease. The steepness depends on the units on both axes, so it is not meaningful to compare slopes across charts with different scales without considering those units. A line that appears nearly flat may still represent a meaningful change if the vertical scale is narrow.

If you display a linear trendline equation, Excel writes it in the form y = mx + b. Here, x is the horizontal-axis value, y is the fitted vertical value, m is the slope, and b is the intercept. For instance, a slope of 3 means the fitted y value rises by 3 units for each 1-unit increase in x. The intercept is the fitted value when x is zero; that may have no practical meaning if zero is outside the observed range.

R-squared, shown as R², is a measure of how closely the selected model fits the observations in the chart. A value nearer 1 indicates a closer fit for that model and dataset; a lower value indicates that the model accounts for less of the observed variation. It does not tell you whether the model is appropriate, whether the relationship is causal, or whether future values will be accurate. A complex curve can achieve a high R² by tracking noise, especially with few data points.

Choosing a trendline type

Excel offers several trendline models. The useful choice depends on the shape of the data and what the variables mean. A model should be plausible as well as visually close to the points.

Linear: Fits a straight line and is a sensible first look when change appears fairly steady. It is commonly used to describe a constant average increase or decrease.
Exponential: Fits a curve that changes at a rate related to its current level, often used for patterns that grow or decline by a percentage over equal steps. It requires positive y values.
Logarithmic: Often rises or falls quickly at first and then levels off. The x values must be positive, so it cannot be used when the relevant horizontal values include zero or negatives.
Polynomial: Fits a curved line with one or more bends. Excel lets you set the order, from 2 to 6. Higher orders can follow more fluctuations, but that can make the line overly tailored to the observed points.
Power: Models a curved relationship between positive x and y values. It is useful only when that kind of relationship is reasonable for the subject.
Moving Average: Smooths short-term variation by averaging a chosen number of neighboring points. It can make a noisy series easier to inspect, but it does not describe the same kind of single equation as a linear fit.

For example, monthly customer counts that rise by roughly the same number each month may suit a linear fit. A balance that grows by a similar percentage each month may be better represented by an exponential model. Those examples are starting points, not automatic rules: inspect the data, understand how it was collected, and compare the model with the real-world process.

Using a trendline to estimate future values

Excel can extend some trendlines forward or backward beyond the observed data. In the Format Trendline pane, enter a value under Forecast to specify how far to extend the line in the horizontal-axis units. For example, on a chart with one point per month, a forward forecast of three extends the model three horizontal units beyond the last point. It extrapolates the chosen model; it does not add new observations or independently forecast the future.

That distinction matters because a pattern that fits the past may change. A linear trend can eventually imply implausibly high or low values, while a seasonal series may be misrepresented by a simple straight line. Forecasts are especially uncertain far beyond the data range, and a high R² within the observed range does not remove that uncertainty. Treat the extension as a scenario based on an assumption, then compare it with domain knowledge and other evidence.

For charts where the horizontal values are actual numbers, an XY (Scatter) chart makes the spacing between x values visible. A line chart typically treats its horizontal entries as categories, so the gap between neighboring labels is visually equal even when dates or numeric values are irregularly spaced. If your observations are unevenly timed, check the chart type and axis carefully before interpreting the line or its forecast.

Example: interpreting a sales chart

Suppose a store charts monthly sales for one year and adds a linear trendline. The line slopes upward, so the fitted monthly values show an overall increase across those twelve observations. If the slope is $500 per month, that means the fitted sales value rises by $500 for each one-month step in the chart, assuming sales are measured in dollars and the horizontal units are months. It does not mean every month’s sales rose by exactly $500; actual values may fluctuate around the line.

If a second series shows the number of visitors, a similar upward pattern does not prove that visitors caused the sales increase. Promotions, price changes, seasonality, or other factors may affect both. A useful next step is to inspect the observations, label the axes and units, and consider whether a different chart or a separate analysis is needed. A trendline is a visual summary, not a substitute for investigating the business question.

Common mistakes and limitations

A frequent mistake is treating the trendline as a path that every data point should follow. Real data are variable; distances between points and the line can be important evidence rather than errors to ignore. Another is choosing a high-order polynomial simply because it produces a high R². That may fit past noise and behave unpredictably outside the observed range.

Check for missing, duplicated, or incorrectly typed values before fitting a line.
Confirm that the series and axis scales match the question you are asking.
Do not confuse correlation or a shared direction with proof of cause and effect.
Be cautious with very small datasets, outliers, and forecasts beyond the observed range.
Use a model whose assumptions and shape make sense for the subject, not just one that looks attractive.

Excel does not add a trendline to every chart type. Trendlines are unavailable for chart types including 3-D, stacked, radar, pie, and doughnut charts. If the option is missing, check whether the chart type supports trendlines and whether a suitable data series is selected. A scatter chart is often a practical choice for examining the relationship between two numeric variables.

Trendline versus a line connecting data points

These two chart features can look similar but answer different questions. A line connecting points joins observations in sequence, showing their order and the ups and downs between them. A trendline fits a model to summarize the overall relationship or direction. On a monthly chart, the connecting line can reveal a sharp drop in a particular month; the trendline may smooth over that event to show the broader direction.

Use connected points when the sequence itself matters, such as daily temperatures over time. Add a trendline when you want to summarize an overall pattern or examine a relationship between variables. You can show both if the chart remains readable, but label the data and trendline clearly so readers can tell observations apart from the fitted model.

Frequently Asked Questions

Does a trendline show the exact future value?
No. It extends a model fitted to existing data. Future conditions may differ, so a forecast is an estimate under the model’s assumptions, not a guaranteed result.

What does a positive trendline mean?
A positive slope means the fitted y values increase as x increases. It describes the direction of the relationship in the selected data; it does not by itself establish causation.

What does R-squared mean on an Excel trendline?
R² summarizes how closely the selected trendline model fits the plotted observations. A higher value indicates a closer fit for that dataset, but does not prove the model is suitable or predictive.

Why can’t I add a trendline to my Excel chart?
The chart type may not support trendlines, or the chart or series may not be selected. Try a supported type such as an XY (Scatter) chart for numeric data, then select the series and check the chart design options.

Should I use a linear or exponential trendline?
Use a linear model when the data plausibly change by a roughly constant amount per step. Consider an exponential model when the rate of change is more plausibly proportional to the current value and the data meet its requirements. Compare the model with the subject and observations rather than relying on appearance alone.

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.