| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
PROBLEMS WITH DISPLAY EQUATIONS ON CHART
In Excel I have added a polynomial trendline to a graph and clicked 'display
equation on chart'. The equation does not represent what the trendline displays. The trendline line goes through all my 6 data points, but the when i use the equation it is wrong. Any idea's please. |
|
#2
|
|||
|
|||
|
I expect you have a limited number of decimals showing in the chart.
You can format the equation to display more. Better yet use LINEST - see my website to use LINEST to get polynomial fit www.stfx.ca/people/bliengme/ExcelTips best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Walter." wrote in message ... In Excel I have added a polynomial trendline to a graph and clicked 'display equation on chart'. The equation does not represent what the trendline displays. The trendline line goes through all my 6 data points, but the when i use the equation it is wrong. Any idea's please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Problems with X Axis for a Line Chart | Charts and Charting in Excel | |||
| Display cell value on a chart. | Charts and Charting in Excel | |||
| Chart problems | Excel Discussion (Misc queries) | |||
| How do I get a chart to display backwards/forwards? | Charts and Charting in Excel | |||
Linear Mode
