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. Trendlines have limitations shared by all charting tools in that they have to be readjusted as more price data comes in. We will now add the equation of the chart by right clicking on any of the point on the chart, select add trendline, then scroll down and finally select.It fits a straight line (using the method of least squares) to the arrays knownys and knownxs. Method 2: Microsoft Office Excel 2003 and earlier versions of Excel The TREND function returns values along a linear trend. , a3, a2, a1 and b are calculated parameters of the function (also named function coefficients or constants) that describe the relationship between x and y, n is the degree of the polynomial (in Excel, the order of a polynomial). In the Category list, click Number, and then change the Decimal places setting to 30 or less. The polynomial trendline is a curved line with the function: y anxn +.Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.Open the worksheet that contains the chart.Using a graph to do it just seems like the simplest way to explain it, but there may be other ways to expand the amount of data points and get values for the unknown numbers using the trend. To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 Assuming I have a linear trend line set through 10 points of data, I would like to create a table that shows 100 points of data on that same trendline. The trendline equation and R-squared value are initially displayed as rounded to five digits. This article explains how to display more digits in the coefficients.

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.

Get equation from trendline excel