Excel Trendline Values: How to Display and Calculate Them

Charts & pivot tables · Updated November 19, 2026

To get trendline values in Excel, select the chart’s data series, add a trendline, and tick Display Equation on chart in the Format Trendline pane. For values in worksheet cells, use that equation or a regression formula such as FORECAST.LINEAR; Excel does not automatically place every chart trendline value in a column.

Display the trendline equation in Excel

These steps apply to Excel for Microsoft 365 on Windows. First, create a chart from your data. For numerical x-values, an XY (Scatter) chart is usually the clearest choice: select the two columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart. Click a plotted data series, right-click it, and choose Add Trendline. If Excel displays a pane, select the trendline type that matches your analysis.

In the Format Trendline pane, open Trendline Options and select Display Equation on chart. Excel puts the fitted equation on the chart as a text label. For a straight-line trend, it will look like y = mx + b, where m is the slope and b is the intercept. The label gives you the coefficients needed to calculate a predicted y-value for a chosen x-value.

You can also add a trendline from the ribbon: select the chart, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options. The exact appearance of the pane can vary slightly by Excel build. In Excel for Mac, select the data series and use the chart’s Add Chart Element or contextual chart controls; the trendline options and equation checkbox are similar. If a command is not available in Excel for the web, open the workbook in the desktop app.

Calculate trendline values in worksheet cells

A chart equation is useful for reading a trend, but calculating the prediction in a cell makes it easier to reuse, sort, or compare results. For a linear trend, Excel’s FORECAST.LINEAR function estimates y for a specified x from known x- and y-values. The function fits a straight line using the source data; it does not read the rounded equation label from the chart.

For example, suppose A2:A5 contains x-values 1, 2, 3, and 4, while B2:B5 contains y-values 3, 5, 7, and 9. Put the new x-value 5 in D2. With those cell layouts, enter =FORECAST.LINEAR(D2,$B$2:$B$5,$A$2:$A$5) in E2. The result is 11, because these points lie on the line y = 2x + 1. The dollar signs keep the source ranges fixed if you copy the formula down, while D2 changes for each new input x-value.

If you want to calculate the straight-line coefficients explicitly, SLOPE returns m and INTERCEPT returns b. With x-values in A2:A5, y-values in B2:B5, and a new x-value in D2, enter =SLOPE($B$2:$B$5,$A$2:$A$5)*D2+INTERCEPT($B$2:$B$5,$A$2:$A$5). For D2 equal to 5, this also returns 11. This is helpful when you want to see or reuse the fitted slope and intercept, rather than rely on the displayed chart label.

To fill a series of predictions, put each desired x-value in D2, D3, and the rows below, then copy the formula in E2 down. The predictions are calculations from the fitted model, not new measured observations. Label the output accordingly—for example, Predicted y—so it is not mistaken for collected data.

Choose the right trendline type

The equation and the resulting values depend on the trendline model. Excel offers several types, and choosing one just because it produces a close-looking line can make forecasts misleading. Start with what the relationship means and whether the assumptions fit your data.

  • Linear: A constant increase or decrease in y for each equal increase in x. Its equation is y = mx + b; FORECAST.LINEAR is a convenient worksheet method.
  • Exponential: A pattern that changes by a roughly constant percentage over equal x-steps. Excel’s chart exponential trendline requires positive y-values.
  • Logarithmic: A pattern that rises or falls quickly and then levels off. The x-values must be positive for this model.
  • Power: A curved relationship in which y changes according to a power of x. Both x- and y-values must be positive.
  • Polynomial: A curved model with one or more bends. Excel lets you select an order; a higher order can follow the observed points more closely but may behave erratically beyond them.
  • Moving average: A smoothed line that averages neighboring observations. It is useful for showing short-term fluctuations, but it does not provide the same kind of equation for calculating predictions.

Excel’s chart equation label is not a universal formula for every trendline type. The linear FORECAST.LINEAR example above should not be used as a substitute for an exponential, logarithmic, or polynomial fit. For those models, use the matching regression method or carefully evaluate the displayed equation, and verify that its form and coefficient precision are sufficient for your purpose.

Understand the equation and R-squared

For a linear equation y = mx + b, m is the change in predicted y for a one-unit increase in x, and b is the predicted value when x is zero. In the example y = 2x + 1, increasing x by one raises the fitted value by two. If x = 5, the fitted y is 11. The intercept can be mathematically part of the line even when x = 0 is outside the range of the data; in that case, it may not have a useful real-world interpretation.

You can also select Display R-squared value on chart in the trendline options. R-squared summarizes how closely the fitted model accounts for variation in the observed y-values under the usual regression interpretation. It does not tell you that the model is appropriate, prove a cause-and-effect relationship, or guarantee accurate future predictions. A complicated trendline can have a high R-squared because it follows the historical points closely, yet still extrapolate poorly.

Keep the chart’s data points visible when assessing the fit. A line that looks persuasive at one chart scale may hide systematic errors, outliers, or a change in the pattern over time. If the question is forecasting, compare predictions with data not used to fit the model where possible.

Why chart values and worksheet results may differ

The equation printed on a chart is a display label, and its coefficients are often rounded. If the label shows y = 2.3x + 1.1, calculations made from those displayed figures may differ from Excel’s calculation using its full-precision fit. A small difference is expected, especially at x-values far from the center of the observed data, where rounding in the slope has more effect.

To show more digits, right-click the equation label, choose Format Trendline Label, and adjust the Number settings, such as the number of decimal places. This improves what you can read, but it does not turn the chart label into a reliable data source. For a linear prediction, calculate from the source ranges with FORECAST.LINEAR or SLOPE and INTERCEPT instead.

Check that the chart and formula use the same observations. A filtered chart, manually selected chart range, blank cells, or an unintended extra row can make the plotted series differ from the ranges used in a worksheet formula. Also confirm that the x-values are numeric rather than text that only looks like numbers.

Use the right chart and x-values

An XY (Scatter) chart treats the horizontal values as numerical x-values and spaces points according to their numeric distances. This matters when the gaps are unequal: for example, measurements taken on days 1, 2, and 10 should not necessarily be treated as equally spaced observations.

A Line chart, by contrast, commonly uses a category axis. Its labels may be dates or numbers, but the points are positioned at category intervals rather than according to the numerical distance between labels. A trendline on such a chart can therefore reflect category order, not the actual spacing represented by the labels. If the interval between x-values has meaning, use a Scatter chart and verify that the horizontal axis is using the intended numeric values.

Excel’s chart trendline options can also include forward or backward forecast periods. Those settings extend the drawn line visually; they do not create a column of forecast results in the worksheet. To obtain individual forecast values, create the future x-values in cells and calculate corresponding predictions with a suitable model.

Common problems and practical checks

  • No equation checkbox: Confirm that you selected a data series and added a trendline, rather than selecting the chart area or a legend. Then open the Format Trendline pane and expand Trendline Options.
  • The equation is missing or the model is unavailable: Some model types require positive data. Check for zero or negative x- or y-values, depending on the selected trendline.
  • Predictions look wrong: Check the order of arguments in FORECAST.LINEAR: the first argument is the target x, then the known y-values, then the known x-values. The x- and y-ranges must contain corresponding observations.
  • The displayed line does not match the formula: Confirm the model type, chart data range, and x-values. A linear formula cannot reproduce a polynomial or exponential trendline.
  • The line extends but no output appears: A chart forecast extension changes the visual line only. Put forecast x-values in worksheet cells and calculate predictions separately.

Before using the results, plot the data, confirm the ranges, and inspect whether the chosen model makes sense over the x-range where you plan to interpret it. Avoid treating extrapolated values far beyond the observations as certain: the trendline describes a fitted pattern, not a promise that the pattern will continue.

Frequently Asked Questions

Can Excel put trendline values into a column automatically?
Not from the chart’s Display Equation on chart option alone. That option displays an equation label. For a linear trend, enter the desired x-values in cells and use FORECAST.LINEAR to calculate matching y-values.

How do I get the exact trendline equation in Excel?
Right-click the data series, choose Add Trendline, and select Display Equation on chart in Trendline Options. The chart label may round coefficients, so use worksheet regression functions for calculations that need more precision.

Why does my trendline formula give a different answer from the chart?
Common causes include rounded equation coefficients, different source ranges, a different trendline type, or a chart using category spacing rather than numeric x-values. Check each of these before comparing results.

Can I use a trendline to predict future values?
Yes, but treat the result as a model-based estimate. Generate the future x-values and calculate the corresponding predictions with a method that matches the selected model. Forecasting beyond the observed range is especially uncertain.

Is R-squared the same as the trendline value?
No. The trendline equation produces fitted or predicted y-values. R-squared is a separate statistic describing aspects of the fit; it is not a y-value and does not by itself establish that a model is suitable.

Related

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.