How to Set Logarithmic Scale at Horizontal Axis of an Excel Graph

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn how to set the logarithm scale as the horizontal axis in Excel. If you want to observe the change of data over a large period of time, then linear scaling is not very helpful. Then, you need to set the logarithmic scale as Excel horizontal axis. So, now, we will see how you do this task in Excel. So, without any delay, let’s start the discussion.


How to Set Logarithmic Scale at Horizontal Axis of an Excel Graph

The logarithmic scale is very helpful when you work with a big range of data. It is a very good technique to observe the change of data over a large period of time. Now, we will show you step-by-step procedures to set the Logarithmic Scale as the horizontal axis in Excel.


STEP 1: Prepare Dataset

  • Here, we have taken the following dataset.
  • In this dataset, there is information about the population of humans and African Elephants over a large range of time.
  • Now, we will plot the change in the population of humans and elephants over this range.
  • As we are working with a large range of time, it will be helpful for us to set the logarithmic scale in Excel horizontal axis of time.

logarithmic scale excel horizontal axis


STEP 2: Insert Scatter Chart

  • To insert the chart, select the data first.
  • Therefore, we have selected the B4:D12 range.
  • Here, we have selected the range with headers.
  • As a result, the header name will be included in the chart automatically.

Step-by-Step Procedures to Set Logarithmic Scale as Horizontal Axis of Excel

  • After selection, go to the Insert tab.
  • After that, from the Charts group, click on the drop-down menu of Insert Scatter (X, Y) or Bubble Chart.
  • Instantly, a wizard will come out and select the following icon from this wizard.
  • For setting the logarithmic scale on the horizontal axis, you need to select Scatter or Bubble charts.
  • In Excel, other types of charts provide the logarithmic scaling on the vertical axis.
  • But, they do not provide logarithmic scaling on the horizontal axis.

  • Instantly, the chart will show up.
  • Now, click on the title of the chart and edit the title of the chart.

Step-by-Step Procedures to Set Logarithmic Scale as Horizontal Axis of Excel

  • In the chart, we are showing the comparison between humans and African Elephants.
  • For this reason, we have given the title Human vs Elephant Population.

Step-by-Step Procedures to Set Logarithmic Scale as Horizontal Axis of Excel


STEP 3: Format Horizontal Axis to Set a Logarithmic Scale on It

  • In the following step, we need to format the axis.
  • To do so, double-click on the chart.
  • As a result, you can see the Format Chart Area window is showing on the right-hand side of the Excel sheet.

  • After that, click on the drop-down menu of Chart Options and select Horizontal (Value) Axis from here.

  • Now, we can modify the horizontal axis.
  • To do so, select the following Axis Options icon.

  • Here, we do not need the axis range of 0 to 2500.
  • As we are working with 500 AD to 2000 AD range, we will change this range.
  • Therefore, in the Minimum field select the minimum range of the horizontal axis.
  • So, we have inserted 100 in the minimum and 2020 in the maximum field.

  • After that, give a tick on the Logarithmic scale.
  • As a result, the horizontal axis has changed to the 10-based Logarithmic scale.

  • In the logarithmic scale, you can also change the base.
  • Here, we have changed the base to 2 from 10.

Step-by-Step Procedures to Set Logarithmic Scale as Horizontal Axis of Excel


Final Output

  • Finally, the horizontal axis is set to the logarithmic scale.
  • Moreover, you can modify the range.
  • For a better view, we have changed the minimum range of the horizontal axis to 400.

Step-by-Step Procedures to Set Logarithmic Scale as Horizontal Axis of Excel


How to Plot Log Log Graph in Excel

The logarithmic scale is very helpful when you work with a big range of data. It is a very good technique to observe the change of data over a large period of time. Previously, we have set the Logarithmatic Scale as the horizontal scale in Excel. Sometimes, it is necessary to change the axis scale to log scale in Excel. If both axes are in the logarithmic scale, then this plot is called Log Log Plot. Let’s follow the steps below to learn the method.

STEP 1: Insert Chart in Excel

  • To insert the chart, we have to select the data first.
  • For this reason, we have selected the B4:D12 range.
  • Here, we have selected the range with headers so that the header name is included in the chart automatically.

How to Plot Log Log Plot in Excel

  • After selection, go to the Insert tab.
  • After that, from the Charts group, click on the drop-down menu of Insert Scatter (X, Y) or Bubble Chart.
  • Instantly, a wizard will come out and select the following icon from this wizard.
  • For setting the logarithmic scale on the horizontal axis, you need to select Scatter or Bubble charts.
  • In Excel, other types of charts provide the logarithmic scale on the vertical axis not on the horizontal axis.

  • Instantly, the chart will show up.
  • Now, click on the title of the chart and edit the title of the chart.
  • In the chart, we are showing the comparison between humans and African Elephants.
  • For this reason, we have given the title Human vs Elephant Population.

How to Plot Log Log Plot in Excel


STEP 2: Modify Axis for Log-Log Graph

  • Now, we need to modify the axes.
  • To do so, click on the horizontal axis.

  • After that, right-click on the mouse.
  • Instantly, a dialog box will pop out.
  • From the dialog box, select Format Axis.

How to Plot Log Log Plot in Excel

  • As a result, on the right-hand side of the Excel Sheet, you can see the Format Axis window.
  • Now, give a tick on the Logarithmic scale.
  • As a result, the horizontal axis is converted into the Logarithmic scale from the Decimal scale.
  • Here, you can choose your base as per your wish.
  • For our chart, we have taken the 2-base system.

  • Then, give a tick on the Logarithmic scale option.
  • As a result, the Vertical axis is also converted into the Logarithmic scale.
  • Before, the decrease in the population of African Elephants was not visible clearly.
  • But, in the LogLog graph, we can see the crisis clearly.

How to Plot Log Log Plot in Excel

  • Finally, we have plotted the graph of LogLog.
  • In the following figure, you can watch what the log-log graph looks like.

How to Plot Log Log Plot in Excel


Download Practice Workbook


Conclusion

In this article, we have demonstrated how to make the logarithmic scale in Excel horizontal axis. There is a practice workbook at the beginning of the article. Go ahead and give it a try. Last but not least, please use the comment section below to post any questions or make any suggestions you might have.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sudipta Chandra Sarker
Sudipta Chandra Sarker

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel. Here I will be posting articles related to this. My educational degree is BSc in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology, Bangladesh. I have a great interest in research and development. I always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo