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
Get FREE Advanced Excel Exercises with Solutions!
