Forecasting...

[guinness123]

Hey relative newbie to excel and stumped! I have a trendline forecasting question that I have no idea how to solve...

I have a group of stats for 4 years:

2006 - 327
2007 - 337
2008 - 325
2009 - 332

I need to find a baseline (average of the 4 years) in order to plan a 25% reduction by 2015.
I though I could use excel using a trendline?!
I have looked to maybe change the trendline equation substituting the "x" for the year...
Any help would be greatly appreciated!

 

[AlphaFrog]

Hi and welcome.

You could use the FORECAST function to calculate a linear forecast.

Excel Workbook
	A	B	C	D	E	F
1	2006	327		Year	Forecast	-25%
2	2007	337		2015	332.5	249.375
3	2008	325
4	2009	332
Sheet

 

[guinness123]

Thanks Alphafrog!
Is it possible to graph this so I can fill in the years in between?