ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   PROBLEMS WITH DISPLAY EQUATIONS ON CHART (https://www.excelbanter.com/charts-charting-excel/21269-problems-display-equations-chart.html)

Walter.

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.

Michael R Middleton

Walter -

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. <


Three ideas:

(1) Click the trendline equation (to select it), and click the Increase
Decimal button repeatedly to display more significant figures.

(2) Be sure to use the XY (Scatter) chart type, not the Line chart type
(which uses X values of 1,2,3,... for the trendline).

(3) If you are using an XY (Scatter) chart type, check to see that the data
on your worksheet are numerical. If a cell has text (that looks like a
number) instead of actual numbers, the trendline uses 1,2,3,... for X.

- Mike
www.mikemiddleton.com




All times are GMT +1. The time now is 09:37 AM.

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