extending line of best fit on excel

mollykins | 15:40 Sun 27th Sep 2009 | Technology

2 Answers

How do i get the linear (line of best fit) trendline to extend so that i can see an estimation for points below and beyond those already plotted?

ps. it is on w. 2007

Dumb question alert! Which discs for digital photos?

Googlle

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by mollykins. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Cheeris

If you left-click on the trendline and then right-click on the trendline (make sure you click ON the trendline and not on the background) there will be an option 'Format Trendline'.

A box will appear - if you make sure 'Trendline Options' is selected, near the bottom of the list of options are two 'Forecast' boxes. Enter the number of periods forward and backward and click on Close to get forecasts added to the trendline.

mollykins

Question Author

ok thanks

1 to 2 of 2

Do you know the answer?