I need the 2E+07 or 20,000,000 to be more specific, such as 21,346,789 or what ever the case may be. This formula is not specific enough for my needs. On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less. After creating a trendline and trendline formula from a graph, the resulting trendline formula is reported in scientific notation.Double-click the trendline equation or R-squared text.

Method 2: Microsoft Office Excel 2003 and earlier versions of Excel In the Category list, click Number, and then change the Decimal places setting to 30 or less.Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.Open the worksheet that contains the chart. 07-05-2019, 12:10 AM 1 CEO76 Registered User Join Date 04-21-2007 Location Where your mind is MS-Off Ver OS 2010, 2013, 365.To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 The trendline equation and R-squared value are initially displayed as rounded to five digits.

Lastly, check the box next to Display Equation on chart: A polynomial trendline with an order of 3 will appear on the scatter plot: We can see that the trendline does a pretty good job of capturing the relationship between the two. This article explains how to display more digits in the coefficients. In the Format Trendline panel that appears, click Polynomial under Trendline Options, then type 3 for the Order. For some purposes, this may not be a sufficient number of significant figures. 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.

Excel polynomial trendline equation