How to get the Excel curve fitting

Enter the experimental data into Excel, two variables of the best two vertical rows.

Select all the data and be careful not to select the text too.

In the menu bar, click Insert, and then select the Drop-down menu under scatter chart.

Choose the type you want from the menu, generally select both the data point and the smooth curve of the scatter plot.

The discovery generated graphics, but there are some problems, such as no axis names, no ticks, and so on.

Open the design in the menu, click the Drop-down menu in the layout of the icon.

You will see icons with many layout types and choose what you need. For example, the layout selected in the figure is a common title, an axis name.

In addition, if linear fitting is needed, the layout shown in the direct selection diagram will give the function expression and relative error directly.

The axes also need to be set: Click on the area near the axis with the mouse, right-click, select Format axis.

This can be set in detail here.