Plotting Partial Trendline

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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?
 
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
 
Back
Top