ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to calculate something using equation from Chart' directly? (https://www.excelbanter.com/excel-worksheet-functions/105257-how-calculate-something-using-equation-chart-directly.html)

pujiyono

How to calculate something using equation from Chart' directly?
 
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.

Bernard Liengme

How to calculate something using equation from Chart' directly?
 
Use LINEST to get the values into cells
see;

http://www.tushar-mehta.com/excel/ti...efficients.htm
http://www.stfx.ca/people/bliengme/E...olynomial.html

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

"pujiyono" wrote in message
...
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.





All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com