Getting the equation of the trend line onto the excel sheet

F

Farooq Sheri

I have graph that is changing continuously and its trendline changes
accordingly. I use the equation of the trendline to do some calculations.
Since the data is quite dynamic and I have a large number of graphs, is there
a way to have the trendline equation printed in a cell. I can then write a
macro to do my calculations.
Thanks.

Farooq
 
F

Farooq Sheri

Thanks; in fact I have to use INTERCEPT function along with either SLOPE or
LINEST to get the answer.

Regards
Farooq
 
J

Jerry W. Lewis

Alternately, Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline.
http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29434786d

If you are using an Excel version prior to 2007, this would be a useful
sanity check. LINEST prior to 2003 can lose numerical accuracy for
numerically challenging problems. LINEST in 2003 is overall much better
numerically, but coefficients of exactly zero are not to be trusted.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top