Plotting Partial Trendline

[Phil Hageman]

Is there a way to keep Excel from plotting a trendline the
same as using #N/A to keep it from plotting series points?

 

[Jon Peltier]

Phil -

Excel offers to extend a trendline beyond the data is is based on, but
you aren't given the option to retract the endpoints of the trendline so
it spans a shorter range.

You could use LINEST or SLOPE and INTERCEPT and construct your own
trendline as a new series in the chart.

- Jon