Extend a Trendline to the Y-Axis in Excel

Charts & pivot tables · Updated November 21, 2026

To extend a trendline to the y-axis in Excel, select the trendline, open Format Trendline, and increase Forecast > Backward until the line reaches x=0. This works most predictably with an XY (Scatter) chart whose horizontal axis uses numeric values. If the chart is a Line chart, convert it to a scatter chart first if you need the trendline to reach a numeric x=0 position.

What You’ll Need

  • An Excel chart with a data series and a trendline. If you have not added one, select the chart, then choose Chart Design > Add Chart Element > Trendline and select an appropriate type.
  • For a precise extension to x=0, an XY (Scatter) chart with numeric x-values. A Line chart treats its horizontal axis as categories, not as a continuous number line.
  • A meaningful reason to extend the fitted trend beyond the observed data. The extension is an extrapolation, so it may not describe what happens outside your measurements.

Step-by-Step

  1. Check what the y-axis represents. In an XY chart, the y-axis is the vertical axis and the x-axis is the horizontal value axis. The y-axis is located where x=0 if the axes are set to cross at zero. If your horizontal values are all positive, the chart may currently show the vertical axis at its left edge instead; that is not necessarily the x=0 position.
  2. Use an XY (Scatter) chart when the x-values are numbers. Click the chart. If it is a Line chart, go to Chart Design > Change Chart Type, choose XY (Scatter), and select a scatter style with markers (with or without straight lines). In the chart-type dialog, check that the correct x and y ranges are assigned to the series. A Line chart spaces categories evenly, even if the labels look numeric, so it cannot reliably represent a numeric distance from a data point to x=0.
  3. Add or select the trendline. Select a data point in the series, then choose Chart Design > Add Chart Element > Trendline and choose a suitable model, such as Linear. If a trendline is already present, click the line itself to select it rather than the data series. When selected, the line should show handles or other selection indicators.
  4. Open the trendline settings. Right-click the selected trendline and choose Format Trendline. Alternatively, press Ctrl+1 on Windows to open the formatting pane for the selected chart element, then make sure the pane is displaying Trendline Options. If Ctrl+1 opens settings for another element, close or refocus the pane and select the trendline again.
  5. Find the backward forecast control. In the Format Trendline pane, select Trendline Options (the chart-shaped icon, if icons are shown). Under Forecast, locate Backward. This setting extends the fitted line toward smaller x-values; it does not change the data, trendline type, or equation.
  6. Enter the distance from the leftmost x-value to zero. For a scatter chart, Backward is measured in horizontal-axis units. If the smallest plotted x-value is 5, enter 5 to extend the line back to x=0. If the smallest x-value is 2.5, enter 2.5. If your smallest x-value is already zero, a backward extension is not needed to reach the y-axis. If the plotted data includes negative x-values and spans zero, the trendline may already cross the y-axis without any forecast extension.
  7. Make sure x=0 is visible and is where the axes meet. Right-click the horizontal axis and choose Format Axis. In Axis Options, check the horizontal axis bounds and the Vertical axis crosses setting. Set the vertical axis to cross at the axis value 0 when that option is available. The horizontal axis minimum must also include zero for the crossing to appear in the plot area. Do not force the minimum to zero if that would hide meaningful negative data; instead, keep the data range and set the crossing at zero.
  8. Check the result and adjust the extension. The trendline should run leftward to the vertical axis at x=0. If it stops short, increase Backward; if it extends past the y-axis, reduce it. Excel may retain more decimal places than the field displays, so use a little more precision if the end appears slightly short. You can click outside the pane to inspect the chart and reopen the pane to fine-tune the value.

For example, suppose a scatter chart’s x-values run from 5 to 18 and its y-values are measurements. Setting Backward to 5 extends the fitted line from the first observed x-value back five x-units, ending at x=0. Setting it to 5 does not mean five data points or five pixels. If the x-values instead run from 50 to 180, the corresponding extension is 50 units.

Common Mistakes

  • Using the number of points rather than x-units. In an XY chart, the Backward value is a distance on the x scale. If observations are at 5, 10, and 15, entering 3 extends only three units, not three observations. Use the difference between zero and the smallest x-value.
  • Assuming the left edge is the y-axis. The plot area’s left edge may represent a nonzero minimum. The trendline can reach that edge and still not reach x=0. Check the axis bounds and crossing location rather than judging only by the chart border.
  • Leaving a numeric series as a Line chart. Line charts use equally spaced categories. A label such as 10 or 20 is not treated as a true x-coordinate, so a forecast distance may not correspond to the numeric gap you intend. Use an XY chart when the horizontal values are measurements, dates represented numerically, or other continuous values.
  • Choosing a model only because it reaches the axis. A longer extension does not make a trendline more reliable. A linear, exponential, logarithmic, or polynomial fit can behave very differently outside the measured range. Select a model that fits the data and has a defensible interpretation.
  • Changing the axis minimum and clipping data. Setting the horizontal minimum to zero can hide negative x-values. If negative values matter, preserve the full range and set the vertical-axis crossing to zero instead.

Tips

  • Keep the units consistent. If x-values are seconds, enter the backward distance in seconds; if they are years, use years. For dates in an XY chart, Excel stores dates as serial numbers, so a distance of 1 is one day, not one year. Calculate the date gap in days if extending to a particular date is appropriate.
  • Display the equation only when it helps. In the Format Trendline pane, you can select Display Equation on chart to see the fitted equation. It can help you understand the model, but the equation label does not extend the line and may be rounded for display.
  • Use a clear chart range. A trendline extended far beyond the observations can visually dominate the actual data. Keep markers visible, label the axis units, and consider noting that the extended section is an extrapolation.
  • Do not confuse a trendline with a series line. A series line connects observed points. A trendline represents a fitted model. The Forecast setting applies to the trendline, so make sure you have selected the fitted line before changing settings.
  • On Mac or Excel for the web: The chart and trendline options are similar, but pane layout and shortcuts can differ. On Mac, use Control-click or a two-finger click to open the context menu if right-click is unavailable; Command+1 commonly opens formatting for the selected chart element. In Excel for the web, select the chart element and use its formatting options; if the Forecast controls are not available in your build, open the workbook in Excel for Microsoft 365 desktop.

Troubleshooting

  • The line does not extend when you change Backward. Confirm that the trendline—not the data series or axis—is selected and that you are editing Trendline Options. Check that the chart type supports the numeric x-distance you expect. In a Line chart, convert to XY (Scatter) and verify the series x-values before trying again.
  • The extension reaches the plot edge but not the y-axis. The y-axis may be positioned at the left edge’s minimum rather than at zero. Format the horizontal axis and set Vertical axis crosses to 0. If zero is outside the visible horizontal bounds, adjust the bounds so zero is included. The Backward amount must still be large enough to reach x=0.
  • The line passes the y-axis. Reduce the Backward value. For a scatter chart whose smallest x-value is positive, use the gap between that value and zero. If the chart’s x-axis minimum is negative but the first data point is positive, the forecast distance is based on the data point, not the visible axis minimum.
  • The Backward box is unavailable or behaves unexpectedly. Select a supported trendline rather than a moving-average line, or try a standard type such as Linear. Also check that the chart is a two-dimensional chart and that the trendline is attached to the intended series. If necessary, remove the trendline and add it again through Chart Design > Add Chart Element > Trendline.
  • The chart looks wrong after conversion. Reopen Chart Design > Select Data and edit the series to confirm the x-values and y-values point to the intended worksheet ranges. A reversed or incorrect range can make both the plotted data and fitted line misleading. Restore the original chart type if the horizontal values are categories rather than numeric measurements.

Frequently Asked Questions

How do I extend a trendline exactly to the y-axis?
For an XY (Scatter) chart, set Forecast > Backward to the distance from the smallest plotted x-value to 0. Set the vertical axis to cross the horizontal axis at 0 and make sure zero is visible.

What does Backward mean in Excel’s trendline settings?
It extends the fitted trendline toward smaller horizontal values. In an XY chart, the amount is measured in x-axis units; it is not a count of data points.

Can I extend a trendline to the y-axis in a Line chart?
A Line chart uses categories on its horizontal axis, so it has no continuous numeric x=0 location in the usual sense. Convert it to an XY (Scatter) chart when the x-values should be treated as numbers.

Does extending the trendline change my source data?
No. The Forecast setting changes how far the fitted line is drawn, not the worksheet values. It also does not add new observations or guarantee that the model is accurate beyond the measured range.

Why is the y-axis not at x=0?
Excel may place it at the horizontal axis minimum, especially when zero is outside the displayed range. In Format Axis for the horizontal axis, set Vertical axis crosses to 0 and include zero in the visible bounds if appropriate.

Can I extend a trendline to the y-axis when x-values are dates?
Only if the date scale and target crossing make sense for your chart. An XY chart stores dates as serial numbers, and backward units are days. Since x=0 is not an ordinary calendar date, use the serial-number distance to the actual date you want the line to reach, rather than treating zero as a calendar year.

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.