How to Change Axis to Log Scale in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is a practical application. With Excel‘s tools and capabilities, you can perform an endless number of operations on a dataset. Frequently, we must examine the percentage rise rather than the exact figures. A standard Chart Axis cannot correctly represent a limited number of numeric values if the other values are high. The logarithmic scale is among the most effective methods for analyzing percentages. This article examines three straightforward methods for applying a log scale to Chart Axis. Therefore, don’t hesitate to go through these three easy ways to Change Axis to Log Scale in Excel.


Download Practice Workbook

Please click the link underneath this section if you want a free copy of the illustration workbook we discussed during the demonstration.


3 Easy Ways to Change Axis to Log Scale in Excel

To illustrate this point, let’s examine a representative dataset. Month and Net Sales are columns in the following dataset. It is crucial to notice that the dataset we will work with has some numeric values, which are remarkably less than the other values. Firstly, we will design a typical Clustered Chart using the dataset’s information. The lower values will not have a better view in the chart. You should employ a logarithmic scale if the difference among values is huge or whether the data showing is much smaller or larger than the overall data. Utilizing all these three methods, we will change the chart Axis to Log Scale in Excel. I’ve also been using Microsoft Excel 365 to compose this post. You are free to select the version that best meets your needs. Whichever option you choose is acceptable to us.

how to change axis to log scale in excel


1. Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

Excel’s Format Tab is hidden by default. However, the Format tab will appear in the ribbon when we begin dealing with a chart object. This subsection will apply a Logarithmic Scale to the chart’s Axis. Please follow these instructions carefully so that the Format Tab can help you complete your task.

STEPS:

  • First, select the B4:C10 range.

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • Second, navigate to the Insert tab and go to,

Insert → Charts → Recommended Charts

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • Subsequently, the Insert Chart window will open, then go to the Recommended Charts tab.
  • Later, pick the Clustered Column chart and hit OK.

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • Consequently, the intended chart will appear like the below one.
  • Next, click the Plus symbol.
  • Latterly, from the Charts Elements, check Axes and Gridlines.

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • At this point, click on the chart area and go to the Format tab, followed by Format Selection.

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • Next, pick the Down Arrow icon of the Chart Options and choose Vertical Axis.

  • After that, select the Axis Options icon.
  • Later, check the Logarithmic scale and input 10 in the Base section.

Utilize Format Tab to Turn Axis to Logarithmic Scale in Excel

  • As a result, the desired output will display like the below one.

Read More: How to Change Axis Scale in Excel (with Easy Steps)


2. Using Context Menu to Establish Log Scale to Excel Chart Axis

The Context Menu is a list of options when you right-click an item. It contains shortcuts to everyday tasks the programmers assumed you’d need. Right-click menu is another name for the context menu. Whenever users right-click on a cell in Excel, the ensuing Context Menu is packed with options. To assign the Log ratio to an Axis in a chart, follow the instructions and use the Context Menu as shown below.

STEPS:

  • To begin, select the B4:C10 field.
  • Second, navigate to the Insert tab and click Recommended Charts.

Using Context Menu to Establish Log Scale to Excel Chart Axis

  • Consequently, the Insert Chart window will open up, then go to the Recommended Charts.
  • After that, choose the Clustered Column chart and tap OK.

Using Context Menu to Establish Log Scale to Excel Chart Axis

  • Due to this, the expected chart will appear and click the Plus icon.
  • Later, from the Chart Elements, check the Axes and Gridlines options.
  • After that, right-click on any value of the Vertical Axis.

Using Context Menu to Establish Log Scale to Excel Chart Axis

  • Subsequently, a context menu will pop up, and then choose Format Axis.

Using Context Menu to Establish Log Scale to Excel Chart Axis

  • As a result, the Format Axis pane will appear.
  • Afterwards, check the Logarithmic scale and write 10 in the Base option.

  • Finally, the proposed chart will be provided, like the following one.

Read More: How to Change X Axis Scale in Excel (2 Useful Methods)


3. Run Excel VBA Code to Change Axis to Log Ratio in Excel

The acronym for Visual Basic for Applications is VBA. Microsoft designed VBA. We can use excel-incompatible functionalities via VBA code, and excel’s VBA offers an innovative alternative for displaying a polar area chart. This tutorial will change a chart Axis to the Log Scale in Excel using VBA. Please complete the assignment by following these instructions.

STEPS:

  • Firstly, choose the desired sheet as the Active sheet.
  • Second, navigate to the Developer tab and pick the Visual Basic symbol.

Run Excel VBA Code to Change Axis to Log Ratio in Excel

  • After that, click on,

Insert Module

  • Later, input the following formula into the Module box.
  • It is essential to modify the range and sheet name as your need.
Sub AxisLogarithmicScale()
    Range("B4:C10").Select
    ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select
    ActiveChart.SetSourceData Source:=Range("ExcelVBA!$B$4:$C$10")
    ActiveChart.SetElement (msoElementChartTitleNone)
    ActiveChart.Axes(xlValue).Select
    ActiveChart.Axes(xlValue).ScaleType = xlLogarithmic
End Sub
  • Next, press  F5  or click the Run symbol.

  • As a result, the expected output will show below.

Output of Running Excel VBA Code to Change Axis to Log Ratio in Excel

Read More: How to Change Y Axis Scale in Excel (with Easy Steps)


Conclusion

From this point forward, you can Change Axis to Log Scale in Excel by following the methods we just covered. You may find many articles similar to this on the ExcelDemy Website. Continue utilizing them, and let us know if you have any additional ideas or other methods for finishing the assignment. Please send any queries or suggestions in the below space.


Related Articles

Lutfor Rahman Shimanto

Lutfor Rahman Shimanto

Hi there! I am Lutfor Rahman Shimanto. I have completed my graduation in Information Technology from Jahangirnagar University. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of work, I enjoy Chess a lot. I am a founding member of the Jahangirnagar University Chess Club and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo