# How to calculate trend line growth rate (as an annual percentage growth rate)

1. ## How to calculate trend line growth rate (as an annual percentage growth rate)

From a chart in Excel I need to automatically calculate what the annual percentage growth rate is of a trend line. Does anyone know how to automate this in Excel? I've attached a sample so you can see what I'm trying to accomplish. Thanks!

Rob  Register To Reply

2. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)

IMO, the best way to automate this sort of thing is to perform the regression directly in the spreadsheet and skip using the chart trendline feature. This is perhaps most easily accomplished using the =LINEST() function http://office.microsoft.com/en-us/ex...in=HA010277524
You may also want to be aware of the LOGEST() function (http://office.microsoft.com/en-us/ma...829.aspx?CTT=1), though it is really just a specific application of the same regression algorithms LINEST() uses.  Register To Reply

3. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)

the LINEST function is not giving me the growth rate of the trend line - or - I do not know how to use the number it is giving me to get the growth rate?  Register To Reply

4. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)

Then the linear regression values are in B29:D29, on daily base, so multiply with 365 for a year
exponential ?

modified attachment  Register To Reply

5. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate) Originally Posted by bsalv Then the linear regression values are in B29:D29, on daily base, so multiply with 365 for a year
exponential ?

modified attachment
thank you!!!!!  Register To Reply

6. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)

Did you found a solution for the exponential part of the question ?  Register To Reply

7. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)

you're a genius! i've never seen this formula before:
=DATE(2000+RIGHT(B1,2),LEFT(B1,2),MID(B1,4,2))
got it. thank you!  Register To Reply

8. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)  Register To Reply

9. ## Re: How to calculate trend line growth rate (as an annual percentage growth rate)  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 