Try the LINEST() function.
http://j-walk.com/ss/excel/tips/tip101.htm
--
David Biddulph
"Farooq Sheri" wrote in message
...
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