View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kai023 Kai023 is offline
external usenet poster
 
Posts: 1
Default 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