|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)
Copyright © 2001 - 2017 MJ Technologies, LLC. All rights reserved.