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

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

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

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

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

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

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

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

• 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.
• 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 Logâ€“Log graph, we can see the crisisÂ clearly.

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

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

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

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

Advanced Excel Exercises with Solutions PDF