Trendline formula is inaccurate in Excel

[EDRIC]

The equation displayed for a trendline on an xy (scatter) chart is incorrect. When you manually substitute values for the x variable, Microsoft Excel then plots the trendline incorrectly.

Microsoft Excel plots trendlines correctly. However, the equation that is displayed may give incorrect results when you manually type x values. For appearance, each x value is rounded in the number of significant digits that are displayed in the chart. This behavior allows the equation to occupy less space in the chart area. However, the accuracy of the chart is significantly reduced, which can cause a trend to appear to be incorrect.

[EDRIC]

Increase the digits in the trendline equation by increasing the number of

• decimal places that are displayed

• In the chart, select the trendline equation.
• On the Format menu, click Selected Data Labels.
• Click the Number tab, and then click Number in the Category list.
• In the Decimal places box, increase the number of decimal places to 30 so that you can see all the decimal places.
• Click OK.