View Single Post
  #4  
Old April 30th, 2010, 01:43 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Excel graphing and equation issues

Rather than copying the trendline parameters, use LINEST to place their
values in worksheet cells. This gives you full precision and the values get
updated should you correct the charting data.
For more see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
http://people.stfx.ca/bliengme/Excel...&%20LOGEST.htm
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"danklebs" wrote in message
...
Okay so here is my problem. For work, I have a curve that I need to put
into
excel and find the equation. So I look at the curve and record data points
from the curve into excel. I will then graph the points and it will
produce a
curve just like the one have on paper. My problem comes when I ask excel
to
produce equations for the curves. The equations it produces do not match
the
curves when I enter a value into the equation. Why does this happen or how
can I fix it?