View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default Trendline question

Please do not cords post. I have answered this in Charts

"juanpablo" wrote in message
...
I have the following data:

Ene-08 Feb-08 Mar-08 Abr-08 May-08 Jun-08 Jul-08
8 5000 3802 10400 7600 7400 9800
With this trendline obtaine from the chart:
y = 44,772x - 2E+06

How do I forecast Ago-08
Should x=8
If I want to forecast Feb-09 should x=14?

Thanks

JP