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.

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.

## 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**.

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.

**Read More: How to Plot Log Log Graph in ExcelÂ **

**Similar Readings**

## 2. Plotting Log Scale on Both Axis in Excel

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**.

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**.

**Read More: Excel Logarithmic Scale Start at 0Â **

**Things to Remember**

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

**Download Practice Workbook**

## 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.

## Related Articles

**How to Calculate Log Base 2 in ExcelÂ****How to Calculate Natural Logarithm in ExcelÂ****How to Take Log of Negative Numbers in Excel****How to Calculate Logarithmic Growth in Excel****How to Log Transform Data in ExcelÂ**

**<< Go Back toÂ Excel LOG Function | Excel Functions | Learn Excel**