Excel Chart Extend Line: Forecast Beyond Your Data

To extend a line beyond the last point in an Excel chart, select the data series, add a trendline, then set a value under Forecast > Forward in the Format Trendline pane. That extends a calculated trendline, not the original data series; to show actual future values, add those values to the chart’s source data instead.

What “extend a chart line” can mean

People use “extend the line” to describe a few different chart changes. The right method depends on whether you want a projection, more plotted observations, or simply a line that reaches farther across the chart area.

Project beyond observed data: Add a trendline and forecast it forward. The extension is an estimate based on the selected trendline model.
Plot actual future values: Add future dates or categories and their values to the chart’s source range. The series then continues through those real observations.
Continue a line visually: Adjust the chart’s axes or layout if the data is already there but the line looks cut off. This does not add data or create a forecast.

These options are not interchangeable. A trendline can suggest a direction, but it does not fill in verified results. Conversely, adding blank future rows may make room on the axis, but it will not create a meaningful line unless the chart has values to plot or a trendline to extend.

Extend a trendline forward in Excel

In Excel for Microsoft 365 on Windows, use a chart that contains the series you want to project. Then follow these steps:

Select the chart, then select the particular line or data series. If the chart has multiple series, make sure the intended series is selected.
On the ribbon, choose Chart Design > Add Chart Element > Trendline > More Trendline Options. You can also right-click the selected series and choose Add Trendline.
In the Format Trendline pane, choose a trendline type, such as Linear, if Excel has not already selected one.
Under Forecast, enter a positive number in Forward. The line extends that many horizontal-axis units beyond the last plotted observation.
Close the pane and check the chart. If the added section is not visible, adjust the horizontal axis maximum or check that the chart has room to display it.

For example, if monthly observations run from January through December, a linear trendline forecast forward by three units can extend roughly three monthly categories past December on a standard line chart. It is a projection of the fitted line, not three extra monthly measurements. The precise interpretation of a unit depends on the chart’s horizontal axis, so check the axis type before treating the forecast as a specific number of days or months.

To extend backward as well, enter a value under Backward. This is useful when you want a fitted line to reach before the first observation, but it does not reconstruct missing historical data.

Choose a trendline that fits the data

The Forecast setting controls how far the line continues; the trendline type controls the shape and calculation of that line. A longer extension does not make a model more reliable. Choose a type that makes sense for the pattern and the question you are asking.

Linear: A straight-line fit that is often a sensible starting point when values rise or fall at a roughly steady rate.
Exponential: A curve for data that changes at a roughly constant percentage rate. It is not appropriate for every upward curve, and its mathematical requirements can prevent it from fitting some data.
Logarithmic: A curve that can rise or fall quickly and then level off, when that shape is supported by the data.
Polynomial: A curved fit that can follow bends in the observations. Higher orders can closely follow past fluctuations without making a dependable forecast.
Moving Average: A smoothed line that reduces short-term variation. It is mainly used to show a rolling pattern; it is not the same as extending a straight-line forecast.

Excel also offers Power as a trendline type. Its suitability depends on the data and the model’s requirements. In general, avoid selecting a curve just because it passes close to every existing point. A complex fit can describe past noise and still project poorly beyond the observed range. If the line will inform a decision, compare the projection with domain knowledge and other forecasting methods rather than presenting the chart trendline as certainty.

Extend the actual data series instead

If you already know the future values, add them to the data behind the chart. For example, suppose a worksheet has months in column A and observed sales in column B through December. Add January, February, and March to the next rows in column A, and enter the corresponding actual or separately calculated values in column B. Include those rows in the chart’s source data; the plotted series will then continue through the new points.

To inspect or change the source range, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, check the chart data range and the series entries. You can edit the range to include additional rows. If the source is an Excel table, adding rows directly below it usually expands the table, and charts based on that table can include the new rows automatically. Confirm the result rather than assuming the chart has updated.

For a chart built from a normal cell range, another option is to select the chart and look for the colored outlines around its source cells. Drag the range handle to include the additional rows, if visible. The Select Data dialog is often clearer when a chart has multiple series or non-adjacent source ranges.

Be careful with formulas copied into future rows. A formula that returns an empty string is not the same as a real blank cell, and chart behavior can vary with the series and settings. If future values are unknown, do not enter invented numbers merely to make the line look continuous. Use a clearly labeled forecast or a trendline and explain what it represents.

Understand axes, categories, and forecast units

The forecast distance is measured along the horizontal axis, but the meaning of one unit depends on the chart. A line chart often uses a category axis: points may be evenly spaced labels such as months, even if the intervals between the actual dates are not equal. In that situation, a forward value commonly corresponds to additional categories or plotted positions, not automatically to a specific elapsed number of days.

A scatter chart uses numeric horizontal values, making it useful when the spacing between x-values matters. For example, if measurements were taken after 1, 2, and 10 days, a scatter chart represents those unequal intervals more faithfully than a standard line chart with three equally spaced categories. A trendline forecast on a numeric axis is interpreted relative to the axis scale. Check the axis labels and units before describing how far the projection reaches.

If the line extends but the chart ends at the final observed category, the axis may need more room. Select the horizontal axis, open Format Axis, and review Bounds or the axis options available for that chart. The controls differ between category and value axes. Changing the axis bounds changes what portion of the axis is displayed; it does not add observations or alter the forecast model.

Line chart, scatter chart, or a separate forecast series?

A trendline is convenient when you want Excel to show a fitted model directly on a chart. It can be formatted separately and, depending on the trendline type and chart, Excel can also display its equation and an R-squared value. These statistics describe the fit to the supplied data; they do not guarantee that a forward projection will be accurate.

A separate forecast series gives you more control over what appears in the legend and how the projected values are calculated. You can put forecast dates and values in their own columns, add that range as another series through Chart Design > Select Data, and format it differently, such as with a dashed line. This makes the boundary between observed and estimated values easier to communicate. It also lets you use a forecast method that is not simply the chart’s selected trendline.

Use a line chart for sequential categories such as months when equal spacing is appropriate. Use a scatter chart when the horizontal values are numeric and their actual spacing matters. If you need to show a forecast interval or several scenarios, a single extended trendline may be too limited; separate series or a more purpose-built chart can communicate the assumptions more clearly.

Common problems and how to fix them

The Forecast control is missing or unavailable: Confirm that a trendline is selected in the Format Trendline pane, rather than the data series or chart area. Trendline options can differ by trendline type and chart configuration.
The extension does not show: Check that Forward is greater than zero and expand the horizontal axis range if necessary. Also verify that you applied the trendline to the intended series.
The forecast goes in the wrong direction: Check the selected trendline type and the order and values of the source data. A trendline follows its model; it does not know what outcome you expect.
The line stops at a blank row: Check whether the chart’s data range includes the intended rows and review how the chart handles empty cells. Select the chart and use Chart Design > Select Data > Hidden and Empty Cells to inspect the available empty-cell display choices. A gap, zero, or connected line can tell a different story.
The line is not a forecast: A chart’s series line connects its plotted points. Extending the axis alone does not carry that line into empty space. Add future values or a trendline, depending on what the extension is meant to represent.

Some chart types and data arrangements do not support every trendline option. If Excel will not add a trendline, try a supported two-dimensional chart such as a line or scatter chart, or use an explicitly calculated forecast series. Avoid changing chart type without checking whether it changes the meaning of the horizontal axis.

Excel for Mac and Excel for the web

In Excel for Mac, the general approach is the same: select the chart series, add a trendline from the chart tools, and edit its options in the formatting pane. Ribbon labels and pane layout can vary somewhat by release. On a Mac, the common copy shortcut is Command+C rather than Ctrl+C; the chart steps themselves do not depend on that shortcut.

Excel for the web supports many common chart editing tasks, but the options available can differ from the desktop application and may change over time. If you cannot find the trendline forecast control in the browser, open the workbook in the Microsoft 365 desktop app and check the Format Trendline pane there. When working in a shared workbook, make sure you have editing permission before changing the chart or its source data.

Frequently Asked Questions

Can I extend an Excel chart line without adding data?
Yes. Add a trendline and set its Forecast Forward value. This extends a model-based line, not the original data series. To extend the plotted series itself, you need additional values in the chart’s source data.

How do I extend a trendline by 12 months?
Set Forecast Forward to the appropriate number of horizontal-axis units. On a monthly category chart, 12 may represent 12 additional categories, but check the chart’s axis and data arrangement rather than assuming the unit always means one calendar month.

Why does my trendline stop at the last data point?
The Forecast Forward value may be zero, the wrong object may be selected, or the chart’s axis may not leave room for the extension. Open the Format Trendline pane, verify the setting, and check the horizontal axis bounds.

Can Excel extend a line through blank cells?
Excel can display empty cells as gaps or use other available empty-cell options, but blanks are not forecast values. To show a projection, add a trendline or provide a separate forecast series with actual calculated values.

Is an extended trendline a reliable prediction?
Not by itself. It extrapolates a pattern fitted to existing observations, and the result can be misleading if the pattern changes or the chosen model is unsuitable. Label it as a projection and explain its assumptions when readers may mistake it for observed data.

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.