#Display equation on openoffice excel how to

On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less. I suggest to begin with only second order polynomial equation : Y a + b.X + c.Double-click the trendline equation or R-squared text.Method 2: Microsoft Office Excel 2003 and earlier versions of Excel The formula in B5 calculates the sum of values in the two cells B3 and B4. You can do this by using a simple copy and paste or click and drag B5 to C5 as shown below. In the Category list, click Number, and then change the Decimal places setting to 30 or less. Type the numbers 4 and 11 into cells C3 and C4 respectively of that spreadsheet.

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 The trendline equation and R-squared value are initially displayed as rounded to five digits. Now, from the popup menu on the right select Display Equation on Chart and you will see the equation displayed on the graph. Then right-click on the line and then select Format Trendline. From the Chart Design ribbon go to Add Chart Element and then linear trendline.

#Display equation on openoffice excel how to

This article explains how to display more digits in the coefficients. You can also display the linear equation on the graph by adding a trendline. 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. Open the worksheet that contains the chart.