# How to Plot a Semi Log Graph in Excel – 4 Steps

## What Is a Semi Log Graph?

Semi-logarithmic or semi-log graphs have one axis on the logarithmic scale and the other on the linear scale:Â  if the Y-axis is in logarithmic scale then the X-axis must be in linear scale and vice versa.

Consider the transformation of the above equation. If you plot y vs. x, you will get an exponential trendline, as y is exponentially proportional to x. But if you plot Y vs. X, you will get a straight trendline, as the deduced equation indicates a straight-line equation. Here, the graph will be a semi-log graph:Â  you plot log(y) vsÂ x.

### Step 1 – Prepare the Dataset

• To apply this method to an existing dataset, go to Step 2. Otherwise, enter 0 in B5, hold CTRL and drag the Fill Handle icon below to create a data series.

• Enter the following formula in C5 and copy the formula down using the Fill Handle:
`=5^B5`

### Step 2 – Insert a Scatter Chart

• Click anywhere in the dataset and go to Insert >> Insert Scatter (X, Y) or Bubble Chart >> Scatter with Smooth Lines and Markers.

• You will see the following chart.

Read More: How to Make a Time Series Graph in Excel

### Step 3 – Format the Axis

• Right-click the y-axis and select Format Axis.

• Check Logarithmic scale and keep the Base to 10.

• The graph is displayed. The trendline changed from an exponential to a straight-line.

### Step 4 – Add Gridlines

• Select the graph, click Chart Element and check Gridlines. If you keep the cursor on the Gridlines element, you will see options to add minor gridlines. You can also do thisin the Chart Design tab.

## How to Read Semi-Log Graph in Excel

• The vertical minor gridlines are uniformly distributed. As each unit along the x-axis is divided into 5 parts, you can read the values corresponding to the minor vertical gridlines as 0, 0.2, 0.4, 0.6, 0.8, 1.0, 1.2, 1.4, 1.6, and so on.
• On the other hand, the horizontal minor gridlines get closer to each other when they approach the major gridline above them. Notice that each section along the y-axis is divided into 10 parts. So you must read the values corresponding to the horizontal gridlines as 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000,2000, 3000, and so on.

## Things to Remember

• You can format the X-axis instead of plotting log(x) vs y.

<< Go Back To How to Create a Chart in Excel |Â Excel Charts |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF