Donate SIGN UP

extending line of best fit on excel

Avatar Image
mollykins | 14: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
Gravatar

Answers

1 to 2 of 2rss feed

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.
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.
Question Author
ok thanks

1 to 2 of 2rss feed

Do you know the answer?

extending line of best fit on excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.