Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Chart trendline formula is inaccurate in Excel
Article ID: 211967 - View products that this article applies to.
This article was previously published under Q211967
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.
Note The trendline formula should only be used when your chart is an XY Scatter chart. This chart plots both the X axis and the Y axis as values. Line, Column, and Bar charts plot only the Y axis as values. The X axis is plotted only as a linear series in these chart types, regardless of what the labels actually are. Therefore, the trendline will be inaccurate if displayed on these types of charts. This behavior is by design.
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.
To work around this behavior, increase the digits in the trendline equation by increasing the number of decimal places that are displayed. To do this, follow these steps:
Article ID: 211967 - Last Review: September 18, 2011 - Revision: 6.0