Hi, Wonder if anyone can help

I am trying to predict some future sales volumes for a hand full of
customers

I have up to 3 years monthly volume sales data.

I can;t seem to get any of the excel worksheet functions to work
(TREND, FORECAST etc)

I do not have enough variables x,y etc

2004 June 2004 July 2004 August 2004 September 2004 October 2004
November 2004 December 2005 January 2005 February 2005 March 2005
April 2005 May 2005 June 2005 July 2005 August 2005 September 2005
October
LONDON 30 19 39 30 31 31 46 48 26 53 38 44
OXFORD 19 13 44 18 34 35 33 30 31 50 30 50
PLYMOUTH 66 46 51 73 80 38 60 54 24 47 52 50
PORTSMOUTH 20 12 36 22 15 16 20 9 28 4 18 19
MANCHESTER 36 77 45 35 55 52 44 33 5 28 44 30
B'HAM 77 93 139 102 132 55 92 143 109 50 86 110
How would i forecast the next 6 months in linear

Thanks

Al


--
MIVELD
------------------------------------------------------------------------
MIVELD's Profile: http://www.excelforum.com/member.php...o&userid=24562
View this thread: http://www.excelforum.com/showthread...hreadid=381525