View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Chad Yun[_2_] Chad Yun[_2_] is offline
external usenet poster
 
Posts: 2
Default plot equation in Excel

Thank you firstly.

My equation likes following format:

aX^2+bXY+cY^2+D=0

Do you have some idea to plot it in an excel chart?

Thanks


"Jon Peltier" wrote:

If you have an equation you wish to plot:

http://peltiertech.com/Excel/ChartsH...tEquation.html

You can calculate slope, intercept, and correlation coefficient from
worksheet data using SLOPE, INTERCEPT, and CORREL worksheet functions, or
compute more statistics using LINEST.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chad Yun" wrote in message
...
The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad



"Chad Yun" wrote:

Does anybody know how to plot any equation within a excel chat? and also
to
calculate the value of R or R2?

thanks alot.