ASP.NET, SQL Server, WPF, C#, VB.NET

I have created a chart that displays Space vs Sales for a given 
 
department for a number of stores for the company I work for. To this I 
 
have applied a logarithmic trendline to show the curve of how sales 
 
change with changes in space & have displayed the equation for this 
 
line. 
 
What I am wondering is, is there a way to capture this equation in to 
 
an Excel cell without manually cutting & pasting it? I have to create a 
 
number of these charts for different departments & need to capture the 
 
equation for each one & doing it manually is taking forever! 
 
If anyone can help, it'd be greatly appreciated. 
 
Thanks 
 
-- 
 
Kai023 
 
------------------------------------------------------------------------ 
 
Kai023's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37647 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=572584

Hi, 
 
Have a read of Tushar's page on the subject 
 
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm 
 
Cheers 
 
Andy 
 
Kai023 wrote: 
 
-- 
 
Andy Pope, Microsoft MVP - Excel 
 
http://www.andypope.info