David Braden has posted code to extract coefficients from the chart
trendline equation

http://groups.google.com/group/micro...440d271303e0d6

You must format the equation to display full precision (scientific w/ 14
decimal places) or you will lose accuracy.

Jerry

Ken wrote:

I have created and X Y Scatter chart and placed an Exponential Trend Line on
it with a good R2 result. I have added the equation to be shown on the chart.

How can I put the Constant values of this equation into separate cells
within the worksheet.

i.e. equation is Y = bE (cX)

I want to put the value of "b" and "c" into separate cells. Can anyone help?