Forecast or Trend or ???

[amerifax]

I have data in a spreadsheet (Excel 2007). The data is by the years 2004-2009(columns) and also January - December (rows).

I have all the data for 2004-2008. In 2009 I only have data for January - June. How can I speculate or forecast what the values will be for July through December?

I read the help on "Project Values in a Series" but I am just not understanding how to do this. I thought that the Forecast command seemed to be what I am looking for but I am not sure.

Any help would be greatly appreciated. A can post the data if that might be easier.

Thanks in advance for any help.

Bob

 

[lemo]

you can use something like

=TREND($b6:$f6,$b1:$f1,g1)

where first range is your data for any given month, second range are the numbers 1 through 5, and the last cell is the next number in sequence, 6.

it's a linear trend though, maybe not appropriate depending on your data.

l