Capturing Equations From Charts
 

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...o&userid=37647
View this thread: http://www.excelforum.com/showthread...hreadid=572584

Capturing Equations From Charts
 

Hi,

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

Cheers
Andy

Kai023 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info