How to create a scatter plot in excel and display the formula

1. First open the excel 2010 software, create a new table and set some data, select the data and click Insert in the Function tab, and select the line chart

2. Then click the drop-down arrow of the line chart and select all chart types

3. Among all open chart types, select Scatter chart type, click the OK button to insert the icon

4. In the inserted scatter chart, select a point in the chart, right-click the mouse, and then click Add a trend line

#5. Then in the menu of trend line options, select the required curve type, in front of the display formula at the lowest end and the display R square Tick ​​the small square

6. After the final settings are completed, the curve of the scatter plot produced will have formulas on it

Recommended related article tutorials: excel tutorial

The above is the detailed content of How to create a scatter plot in excel and display the formula. For more information, please follow other related articles on the PHP Chinese website!