Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I created a simple curve on excel using data points.How can I get the
polynomial equation of the curve ? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Naty
Right click on one of your data points and select Add trendline. The trendline dialog boxes offers a number of options for type of trendline, showing equations in chart etc. HTH Martin |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Or you can use LINEST; see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Naty" wrote in message ... I created a simple curve on excel using data points.How can I get the polynomial equation of the curve ? |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Well, thanks for the advice, but I think since my curve is not linear or
something, it doesn't give me the Add trendline option. My curve looks like a 3rd order polynomial. "MartinW" wrote: Hi Naty Right click on one of your data points and select Add trendline. The trendline dialog boxes offers a number of options for type of trendline, showing equations in chart etc. HTH Martin |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Naty,
You have to be using an XY Scatter chart, not a line graph. The scatter graph allows for polynomials from 2nd to 6th orders amongst other options. How is your curve and data setup? Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How To Fit An Equation To A Curve | Excel Discussion (Misc queries) | |||
How can I curve fit in Excel? | Excel Discussion (Misc queries) | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION? | Excel Worksheet Functions | |||
watch a curve change over time like a movie | Charts and Charting in Excel |