How to graph a logarithmic function in Excel: detailed steps

How to draw a logarithmic function graph in an Excel table? It is very convenient to make charts in an Excel table. Now if you want to draw a logarithmic function graph in an Excel spreadsheet, you can make the continuous curve function more visual. How to do it specifically? Let’s take a look at the specific method of drawing a logarithmic function graph in an Excel table!

1. Open Excel 2016, enter 0.01 in cell A1 in the edit bar and select column A.

#2. Click the [Start] option in the interface toolbar, find [Sequence] in [Fill] and click it.

3. A sequence window will pop up. We set the [Step Value] to 0.01 (Note: This value is very critical, because the smaller the value, the smaller the curve. Smooth), set the [End Value] to 5 (this value is filled in according to your own needs, that is, fill in the function you draw). After setting, click the [OK] button at the bottom.

#4. Obtain the abscissa sequence of the image as shown in the figure.

#5. We enter "=LOG10(A1)" in cell B1, which means to find the value of the logarithmic function with base 10.

6. Directly drop down to fill in, and you can find out all the corresponding ordinate values ​​(log values)

7. Select columns A and B, click [Insert] in the toolbar, find [Scatter Plot with Smooth Line] in [Scatter Plot] and click it.

The above is the specific method of drawing a logarithmic function graph in an Excel table. Isn’t it very simple?

The above is the detailed content of How to graph a logarithmic function in Excel: detailed steps. For more information, please follow other related articles on the PHP Chinese website!