Article ID: 282135 - View products that this article applies to.
This article was previously published under Q282135
When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient. For some purposes, this may not be a sufficient number of significant figures. This article explains how to display more digits in the coefficients.
Display More DigitsThe trendline equation and R-squared value are initially displayed as rounded to five digits. To display a greater number of digits, use one of the following methods:
Method 1: Microsoft Office Excel 2007
Method 2: Microsoft Office Excel 2003 and earlier versions of Excel
Article ID: 282135 - Last Review: January 19, 2007 - Revision: 2.2