Add value of a trendline

I have a graph of the revenue for the last 24 months. I added a trendline
to give me the next months. Can I get the exact value of the those trends
for the next 6 months?

Hello:

First make sure that you have the equation, if not right click the trend line and choose
equation. You can on the same option page choose to forecast forward if you wish, but it will
not supply the actual numbers, you would have to read from the graph. Assuming that is not
what you want then after you get the equation something like this:

y = 601.64x + 1.1369 (this is from some random numbers I used).

the rate of increase in y is the 601.64, you can just add that to the last value and it will
give you the next value etc. So if the last value is in A20 then in a21 enter: = a20+601.64,
you can copy this for as many periods as you want.

This all assumes that you chose a linear trend if you did not then you should use this second
method. Use the entire equation but you need to plug in an X that is consistent with units
that are being used on the abscissa (x axis). For the above the equation the units started
at 1 and increase by 1. So to forecast for the 15th period you would use Y =
601.64*15+1.1369, or for the 50th period use Y = 601.64*50+1.1369. (If it is not non linear
you will have additional terms in the equuation.)

Pieter Vandenberg


Peter Doherty <Peter [email protected]> wrote:
: I have a graph of the revenue for the last 24 months. I added a trendline
: to give me the next months. Can I get the exact value of the those trends
: for the next 6 months?