Excel Tip of the Day


Forecasting trends using charted data (Excel 97/2000/2001/2002)


When you add a trendline to a chart, you can extend the trendline to predict likely results based on your existing data. To do so, select an appropriate chart and then choose Chart | Add trendline from the menu bar. Select an appropriate trendline from the Trend/Regression Type panel (you can use any type except Moving Average with this technique). Then, click on the Options tab.

You can extend the trendline forward or backward from your existing data using the controls in the Forecast panel. Once you've set the desired number of units, click OK. Now, your trendline is extended forward or backward and you can use the trendline to visually deduce the approximate y-value for a given x-value.



(Content provided by Element K Journals)


(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
 
PrintPrint CloseClose

Copyright © 2001 - 2017 MJ Technologies, LLC.  All rights reserved.