How to Plot Log Scale in Excel (2 Easy Methods)

If you want to plot log scale in Excel, this article will be helpful for you. Here, we will demonstrate to you 2 easy and simple methods to do the task smoothly.

Download Practice Workbook


2 Methods to Plot Log Scale in Excel

The following table contains the Name, Month, and Salary columns. We want to plot log scale in Excel for this table. To do so, we will go through 2 simple and easy methods. Here, we used Excel 365. You can use any available Excel version.

How to Plot Log Scale in Excel


1. Using Format Axis Option to Plot Semi-Log Graph in Excel

When only one of the axes of a graph has a logarithmic scale, it is called a semi-log graph. Here first, we will draw a graph by using the data of the Month and Salary column. After that, we will plot the log scale on the Salary axis using the Format Axis option.

Steps:

  • First, we will select the entire Month and Salary columns.
  • Further, we will go to the Insert tab >> select Recommended Chart.

An Insert Chart dialog box will appear.

  • Afterward, we will select All Chart >> select Column.
  • Next, you can select the chart according to your choices, here we selected the red color marked box chart.
  • Then, click OK.

How to Plot Log Scale in Excel

We can see our inserted chart in the following picture. Later, we changed the Chart Title and Axis Title.

Now, we will plot the log scale in this chart.

  • First, we will select the data from the Salary axis >> we will right-click.
  • After that, we will select Format Axis from the Context Menu.

We will see a Format Axis dialog box appears at the right end of the Excel sheet.

  • Then, we will mark the Logarithmic scale.

Here, we keep the Base as 10, you can change the Base according to your needs.

Finally, we can see the semi-log graph in Excel.

How to Plot Log Scale in Excel

Read More: How to Plot Log Log Graph in Excel (2 Suitable Examples)


Similar Readings


2. Using Log Scale on Both Axis

In the following table, we will use the data of the No. of Units and Unit Price columns to insert a Scatter with Straight Lines and Markers graph. After that, we will plot log scale on both axes using the Format Axis option.

Steps:

  • First, we will select the entire No. of Units and Unit Price columns.
  • Further, we will go to the Insert tab >> select Insert Scatter (X, Y) or Bubble Chart.
  • Afterward, select Scatter with Straight Lines and Markers graph.

Next, we will see the Scatter with Straight Lines and Markers graph. Later, we changed the Chart Title and Axis Title.

How to Plot Log Scale in Excel

Now, we will plot the log scale on both axes of the graph.

  • First, we will select the data from the Unit Price axis >> we will right-click.
  • After that, we will select Format Axis from the Context Menu.

We will see a Format Axis dialog box appears at the right end of the Excel sheet.

  • Then, we will mark the Logarithmic scale.

Here, we keep the Base as 10, you can change the Base according to your needs.

We can see the graph which has a logarithmic scale on one axis.

Now, we will plot the log scale on the No. of Units axis.

  • First, we will select the data from the No. of Units axis >> we will right-click.
  • After that, we will select Format Axis from the Context Menu.

We will see a Format Axis dialog box appears at the right end of the Excel sheet.

  • Then, we will mark the Logarithmic scale.

Here, we keep the Base as 10, you can change the Base according to your needs.

Finally, we can see the graph which has log scale on both axes.

How to Plot Log Scale in Excel

Read More: Excel Logarithmic Scale Start at 0 (A Detailed Analysis)


Things to Remember

  • We have to choose an Insert Scatter (X, Y) or Bubble Chart to plot the log scale on both axes.

Conclusion

Here, we tried to show you 2 methods of how to plot log scale in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website ExcelDemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo