Extracting Trendline Equation to a cell(s)

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have searched this Forum and the Internet and the answer I find is to use:

http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29434786d

Unfortunately I don't know how to apply this code. Is there an easy way for
a VBA newbie to use code this successfully and apply this code to a
worksheet(s)?

I have 30+ Charts to graph with data that will change at managements whim.
The equation will then compute a series of what ifs based on given Volumes.

Can someone help?

Thanks
 
Thanks for the quick reply.

I hate to say this but:

Power Trendline is what I need
Equation: y=c*x^b
c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))
b: =INDEX(LINEST(LN(y),LN(x),,),1)

How do I establish the x and y vales sets, is this from the chart or the
data? In either case how do I input the values?

Dave
 
Ok I figured out the values of x & y, now the next question, can the arry
chage based on the selection using the cursor.

Exmpale, as I move the selection up and down the cell ranges, can the name
follow these values?

Thanks
 
Back
Top