How to calculate something using equation from Chart' directly?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pujiyono - 16 Aug 2006 10:53 GMT

How to calculate something using equation from Chart' directly?
I have some equation that gerenarted from the trendline in the chart (Power
equation). The other iteration want to use the formula directly from the
chart. Somehow I don't know how to do that since I can't find in the Help.

Reply to this Message

Bernard Liengme - 16 Aug 2006 14:21 GMT

Use LINEST to get the values into cells
see;

http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm
http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.html

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> How to calculate something using equation from Chart' directly?
> I have some equation that gerenarted from the trendline in the chart
> (Power
> equation). The other iteration want to use the formula directly from the
> chart. Somehow I don't know how to do that since I can't find in the Help.

Reply to this Message