Quizzes & Puzzles1 min ago
extending line of best fit on excel
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
ps. it is on w. 2007
Answers
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.
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.
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.