On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.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.To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 Then, in the 'Decimal Places' textbox enter however many digits you want. In the right pane from the Category list select Number. In the resulting Format Trendline Label, select the Number tab. The trendline equation and R-squared value are initially displayed as rounded to five digits. Answer Tushar Mehta Replied on SeptemReport abuse Double-click the box containing the equation. For instance, my trendline equation is 1E-06x, but I need it to display 3 digits after the decimal (ex. This article explains how to display more digits in the coefficients. ED EddieHurtado Created on NovemHow can I format the trendline equation on a mac device Im on a Microsoft 365 account using excel. For some purposes, this may not be a sufficient number of significant figures. If you want to add more decimal points to the values in the equation, select the trendline equation, and then choose. You will be given the option for how many decimal places to display. 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. Under NumberCategory select Number or Scientific from the drop down list.

Excel trendline equation decimal places