View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Martin
 
Posts: n/a
Default Trend Line Constants

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?

------------------

I don't believe you can capture the constants simply from the graph. However,
ask the Excel help system about the LOGEST( ) function which will provide them.

Bill