I am trying to produce a graph on Excel which shows projected monthly usage of a service based on historical monthly usage figures.
Can any of the stats ninjas on here tell me how to do this?
Ta in advance.
right click on the line, add trendline, under options is the bit where you can forecast x periods
[IMG] 
[/IMG]
Thats exactly what I was wanting to do.
Ta very much
unless there are seasonal or time lag issues.......
beamers - MemberI am trying to [b]produce a graph on Excel which shows projected monthly usage of a service based on historical monthly usage figures[/b].
Can any of the stats ninjas on here tell me how to do this?
Ta in advance.
Christ - I hope you don't work at the Treasury
Christ - I hope you don't work at the Treasury
Fortunately not. Although I'm sure that those who do could learn a lot from this forum.