View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Trend Line Equation Coefficients

If you really are using an exponential fit < y=Aexp(Bx) see
http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
If you are using a power fit < y = Ax^B then see the lower half of
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jake" wrote in message
...
Is there a way to link to the coefficients of a trend line? I have some
data
plotted with a exponential trend line fitted to it and the equation of the
trend line (y = cx^d) shown on the chart. Rather than manually copying c
and
d to use them in another worksheet, I would like to link to them so that I
don't have to re-copy everytime my data changes. Can this be done?

Thanks.