Excel Extend Trendline Beyond Data Points?

Yes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element > Trendline > More Trendline Options, then enter a number in Forecast > Forward in the Format Trendline pane. Excel draws the selected trendline beyond the existing data; it does not add forecast values to your worksheet.

What extending a trendline does

A trendline is a model fitted to the data series in a chart. Extending it projects that model past the last plotted point, or backward before the first point. Excel calls these extensions forecasts. They are a visual extrapolation: Excel continues the chosen trendline equation, but it does not know whether the real-world process will continue to behave the same way.

This is useful when you want to show a possible direction beyond the observations—for example, a sales series that appears to rise steadily, or a measurement that follows a curve. The extended line can make the assumption easy to see. It should not be mistaken for newly measured data, a guarantee, or a separate set of forecast figures. The original cells and chart data remain unchanged.

You can extend a trendline forward, backward, or both. Forward means beyond the latest point in the series; backward means before its earliest point. The projection length is set in the trendline options. If the line does not appear as far as expected, the chart’s horizontal axis limits or chart type may affect what is visible.

Steps to extend the line in Excel

Select the chart that contains the data series. If it has no trendline yet, use Chart Design > Add Chart Element > Trendline and choose a type, or select More Trendline Options to open the formatting pane.
To change an existing trendline, click the line on the chart. Right-click it and choose Format Trendline. If selecting the line is difficult, use the chart’s selection controls to choose the trendline rather than the data series.
In the Format Trendline pane, open Trendline Options. Under Forecast, enter the desired amount in Forward. Use Backward if you also want to extend the line before the first observation.
Click elsewhere in the workbook to apply the setting, then check that the chart displays the full extension. If needed, adjust the horizontal axis bounds so the added portion fits within the plot area.

In Excel for Mac, select the chart and use the Chart Design tab to add a trendline; selecting and formatting the line opens the Format Trendline pane, where forecast options are available. Ribbon layout can vary slightly by release. In Excel for the web, chart editing options may be more limited or arranged differently. If you cannot find the forecast controls, open the workbook in the desktop Excel app.

What does the Forecast Forward number mean?

The forecast number is not a percentage and is not a count of how many data points Excel will insert into the worksheet. It tells Excel how far to continue the trendline along the chart’s horizontal scale. What one unit represents depends on the chart and axis.

XY (scatter) chart: The horizontal axis represents numeric x-values, so the forecast distance is interpreted in those x-axis units. If the last x-value is 3 and the forward setting is 3, the projection reaches about x = 6.
Category chart: A line chart with a category axis spaces categories in sequence. The forecast is based on that sequence rather than on a numeric measurement between labels. It does not infer the actual time gap between irregularly spaced labels.
Date axis: Date-based charts can use time intervals on the horizontal axis. Confirm how the axis is configured and inspect the displayed extension, especially when dates are unevenly spaced or the axis uses a particular date unit.

For example, imagine an XY scatter chart with points (1, 10), (2, 12), and (3, 14). A linear trendline follows y = 2x + 8. Setting Forward to 3 extends the line three x-units beyond x = 3, to x = 6, where the model gives y = 20. This is the line’s prediction, not a new value entered into the data table.

Choose a chart that matches your data

If the spacing between x-values matters, an XY scatter chart is usually the clearest choice. It treats x-values as numbers, so observations at x = 1, 2, and 10 are not misleadingly spaced as if they were equally far apart. A line chart is often suitable for ordered categories or evenly spaced periods, but its horizontal axis may treat labels as categories rather than as measured x-values.

Check the chart before interpreting a forecast. A line extended across a category axis can look like a prediction for a specific date even if the chart only represents category order. Conversely, an XY chart with date serial values can represent actual spacing, provided the x-values are valid Excel dates or numbers. For observations recorded at irregular intervals, using a chart and axis that preserve those intervals helps the visual projection make sense.

Excel offers several trendline models, including linear, exponential, logarithmic, polynomial, power, and moving average. Availability depends on the chart and data. The trendline type affects the shape and therefore the forecast: extending a straight line is a different assumption from extending a curve. Choose the chart first, then select the model that has a defensible relationship to the data.

How to choose a trendline type

A trendline should describe a plausible pattern in the observations, not simply produce the most attractive extension. A linear model is often a sensible starting point when values change by roughly similar amounts over equal x-intervals. An exponential model may suit a pattern that grows or falls by roughly similar proportions, while a polynomial can follow bends in the observed data. More flexibility can also make a curve fit noise rather than a durable relationship.

Linear: Projects a constant rate of change. It is easy to interpret, but a straight line can eventually imply impossible values in some settings.
Exponential: Projects proportional growth or decay. Do not use it automatically just because the data rise quickly; verify that the model is appropriate for the values and context.
Logarithmic or power: These create curved relationships with particular mathematical constraints. Check that the data and x-values are suitable before relying on an extension.
Polynomial: Can follow one or more changes in direction. A high-degree curve may swing sharply beyond the data, so a close fit to past points does not make its long-range forecast reliable.
Moving average: Smooths short-term variation to show a pattern. It is not the same as a fitted equation that establishes a causal or long-term forecast.

Excel can display a trendline equation and an R-squared value through options in the Format Trendline pane. These can help describe the fit to the points shown, but neither proves that the model is correct outside the observed range. In particular, a high R-squared value does not guarantee accurate extrapolation.

Why the extension may not look right

If the forecast is set but the line appears to stop at the last point, first check the horizontal axis. Right-click the axis, choose Format Axis, and review its bounds and scale. A manually fixed maximum may clip the extension; allowing an appropriate maximum or changing the bound can make more of the line visible. Also check that the trendline is attached to the intended data series, especially when a chart contains several series.

Other common causes include an unsuitable chart type, a forecast value that is too small to notice at the current scale, or a category axis that does not represent the intervals you intended. A very large forecast distance can compress the observed data into a small part of the chart, making the fitted pattern difficult to judge. Try a shorter extension first and then adjust the chart scale deliberately.

Remember that a chart’s plotted line and its source data are separate things. Forecast settings extend the trendline’s display; they do not populate future dates, calculate a reusable forecast column, or update a data table. If you need actual forecast numbers for other calculations, use a forecasting method or worksheet formula suited to that task, and keep the assumptions visible.

Trendline extension versus adding forecast data

Use the chart’s forecast setting when your goal is to illustrate the continuation of a fitted model. It is quick, preserves the original observations, and keeps the projection attached to the chart. It is less useful when you need a forecast value in a cell, want to compare several forecasting methods numerically, or need to report forecast intervals and assumptions.

For a report that must show projected values, create a separate forecast table with future x-values and calculated estimates, then add those estimates as another chart series. That approach makes the numbers inspectable and lets you style observed and forecast data differently—for example, using a dashed line for estimates. Clearly label the forecast series and avoid presenting estimates as observed measurements.

Excel also has dedicated forecasting tools for some time-series tasks, such as forecasting from historical values with a seasonal pattern. Those tools answer a different question from simply extending the chart’s trendline. They can account for patterns that a basic trendline does not, but the result still depends on the quality and suitability of the source data. Compare the method to your purpose rather than assuming that every upward line is a reliable forecast.

Interpreting the result responsibly

Extrapolation is generally more uncertain farther from the observations. A model that describes the recent part of a series may fail when conditions change, when a natural limit is reached, or when the original pattern was caused by a temporary event. A linear trend that continues indefinitely, for example, may imply negative demand or unlimited growth even when neither is realistic.

Use an extension as a visual aid, and explain what it represents. State the trendline type, the forecast horizon, and any important assumptions when readers might otherwise treat it as a firm prediction. If the chart supports a business, scientific, or operational decision, compare the projection with domain knowledge and alternative scenarios. A concise chart is helpful; a chart that hides uncertainty is not.

Frequently Asked Questions

Can I extend an Excel trendline in both directions?
Yes. In the Format Trendline pane, enter a value in both Forward and Backward under Forecast. Each value extends the line along the chart’s horizontal scale in that direction.

Does extending a trendline add future values to cells?
No. It changes the line shown on the chart only. To use forecast values in calculations, create a separate forecast table or use an appropriate forecasting method.

Can I extend a trendline on a scatter chart?
Yes. Scatter charts support trendlines, and their numeric horizontal axis makes the forecast distance especially clear when x-values represent measured quantities. Make sure the x-values and their units are correct.

Why is my extended trendline not visible?
The chart’s horizontal axis may stop before the forecast portion, or the extension may be too small to see at the current scale. Check the axis bounds, confirm the forecast value, and make sure you selected the trendline for the correct series.

Is a trendline forecast the same as a reliable prediction?
No. It is an extrapolation of the selected model, not proof that future observations will follow it. The farther it extends beyond the measured data, the more important it is to question the model and communicate uncertainty.

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.