1. For example, as shown in the figure below, the data should be plotted as double logarithmic coordinates.

2. Select all data, click Insert, click Chart, and select Scatter Chart to open the following interface.

3. Select and click the smooth line scatter chart, and the interface will become as shown in the figure below.

4. Click Finish.

5. Beautify the shape of the chart, and it will look like the picture below.

6. Right-click the X axis to display the axis format.

7. Click the axis format, select the scale, and then check the logarithmic coordinates.

8. Click OK to automatically generate the logarithmic coordinates of the X axis.

9. Similarly, the logarithmic coordinate method of Y axis is the same as the logarithmic coordinate method of X axis above.

10. Up to now, the graph still lacks double logarithmic coordinate lines. Right-click the mouse in the graphics area and find the icon option.

1 1. Right-click the icon option, select Grid Lines, and then select All Grid Lines.

12, click OK, and the log-log diagram is completed.

Definition of double logarithmic coordinates:

Double logarithmic coordinate refers to a plane coordinate system in which the unit length of two coordinate axes is calculated by logarithm.

Basic principles of using double logarithmic coordinates;

1. It is necessary to divide the starting point of the curve into expanded forms.

2. When a nonlinear relationship needs to be transformed into a linear relationship.

3. The gradient selection of coordinate axis should conform to the law of logarithmic operation.