How to display intersection coordinates in excel

How to display intersection coordinates in excel: First, use a scatter chart to draw the data, and select "Trend Line"; then select "Display Formula" and "Display R Squared Value"; then compare the two curves Both are fitted; finally, two functions are obtained to find the intersection point.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to display intersection coordinates in excel:

1. Use EXCEL's line chart or scatter chart with smooth lines to draw the data.

2. Click the cross in the upper right corner of the chart, select "Trend Line", right-click the triangle on the left, and then select More Choices.

3. Select "Linear" in [Trend Line Options], and select "Show Formula" and "Show R Squared Value" in [Trend Forecast].

4. From the [Trend Line Options], you can see that there are different fittings, so you can try different fitting methods to get the best one.

#5. By fitting both curves, two functions can be obtained.

#6. There are two functions that jointly calculate the intersection point as (3,5), so based on this point, two sets of auxiliary data are set up.

A set of abscissas are all 3, and a set of ordinates are all 5.

#7. Right-click the chart, insert data, and insert the data just now.

8. Set the thickness of the auxiliary line to 0.5 points, the color to black, the dash type to dashed line, and delete its label. The final effect is as follows ：

##Related learning recommendations: excel tutorial

The above is the detailed content of How to display intersection coordinates in excel. For more information, please follow other related articles on the PHP Chinese website!