Capturing Equations From Charts

[Kai023]

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

 

[Andy Pope]

Hi,

Have a read of Tushar's page on the subject
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

Cheers
Andy