Input the experiment data into the excel file. It is best to make two vertical bars for the two variables.
Excel
Select all the data and do not select the text.
Excel
Click "Insert" in the menu bar and select the drop-down menu under "scatter chart.
Excel
Select the desired type from the menu. Generally, select a scatter chart with both data points and smooth curves.
Excel
The image is generated, but there are some problems, such as no coordinate axis name or scale.
Excel
Open the design in the menu, and click the drop-down menu in the icon layout.
Excel
You can see many Layout icons and select what you need. For example, the layout in the graph is commonly named "title" and "Axis name.
Excel
In addition, if linear fitting is required, directly select the layout shown in the figure. This will directly give the function expression and relative error.
Excel
You also need to set the axis: Right-click the area near the axis, and select "set axis format ".
