Mastering Semi-Log Graphs in Excel: A Step-by-Step Guide

Walter Jul 15, 2026

In the realm of data visualization, graphs play a pivotal role in communicating complex information effectively. Excel, a robust tool by Microsoft, offers a range of graph types to aid in this process. One such type is the semi-log graph, which is instrumental in visualizing data where one axis needs to show values over a wide range. Let's delve into how to create a semi-log graph in Excel.

Making a Semi Log Graph in Excel
Making a Semi Log Graph in Excel

Before we proceed, ensure that you have a dataset ready for graphing. For this guide, let's assume we're using data on population growth, with years ranging from 2000 to 2020 and corresponding population numbers.

Make a Logarithmic Graph in Excel (semi-log and log-log)
Make a Logarithmic Graph in Excel (semi-log and log-log)

Understanding Semi-Log Graphs

A semi-log graph in Excel allows you to use a linear scale for one axis (e.g., time) and a logarithmic scale for the other (e.g., population). This is particularly useful when you want to compare data that spans several orders of magnitude.

How to Create Log and Semi-Log Graphs in Excel
How to Create Log and Semi-Log Graphs in Excel

In our case, population numbers can vary significantly from year to year, making a standard linear graph less informative. A semi-log graph will allow us to see both the minor and major changes in population more clearly.

Preparing Your Data

Semi Log Graph In Excel
Semi Log Graph In Excel

Before creating the graph, ensure your data is in a single column for each series. In our case, we have two columns: one for 'Year' and another for 'Population'. Make sure there are no blank cells or errors in your data.

For better visualization, sort your data in ascending order. To do this, select the data, go to the 'Home' tab, click on 'Sort & Filter' in the 'Editing' group, and choose 'Sort A to Z'.

Creating the Semi-Log Graph

How to Create Log and Semi-Log Graphs in Excel
How to Create Log and Semi-Log Graphs in Excel

Now that your data is ready, let's create the semi-log graph. Select the data you want to graph, then click on the 'Insert' tab in the Excel ribbon. In the 'Charts' group, choose the scatter with smooth lines and markers chart. This chart type is suitable for our semi-log graph.

Once the chart is inserted, click on it to select the Chart Tools, then click on the 'Design' tab. In the 'Current Selection' group, choose 'Select Data'. This will open the 'Select Data Source' dialog box.

In the 'Legend Entries (Series)' section, ensure your data series is listed. If it's not, click on 'Add', then select your data range and click 'OK'. Click 'OK' again to close the 'Select Data Source' dialog box.

Make a Logarithmic Graph in Excel (semi-log and log-log)
Make a Logarithmic Graph in Excel (semi-log and log-log)

Now, let's make the changes to create a semi-log graph. Click on the chart to select it, then click on the 'Design' tab under Chart Tools. In the 'Axis' group, click on 'Select Axis'. In the drop-down menu, choose the vertical axis (usually the one showing 'Population').

In the 'Format Selection' pane that appears on the right, under 'Axis Options', you'll see 'Axis Options'. In the 'Scale' section, change the 'Axis Type' to 'Logarithmic'. This will switch the vertical axis to a logarithmic scale.

A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel
How to Plot Log Log Graph in Excel (2 Suitable Examples)
How to Plot Log Log Graph in Excel (2 Suitable Examples)
the screenshote screen shows an image of a computer monitor with numbers and symbols on it
the screenshote screen shows an image of a computer monitor with numbers and symbols on it
Progress Tracker in Excel‼️ #excel
Progress Tracker in Excel‼️ #excel
Noob to Excel Pro
Noob to Excel Pro
How to Use Graph or Chart in Excel Google Sheets
How to Use Graph or Chart in Excel Google Sheets
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
a poster showing how to use chart in excel
a poster showing how to use chart in excel
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel

Now, let's format the graph for better readability. Click on the title of the vertical axis (the one showing 'Population'). Type 'Population (Log scale)' to make it clear that this axis is on a log scale. You can formatting to make the graph more aesthetically pleasing.

Finally, right-click on the graph and select 'Add Chart Element' > 'Axis Titles'. Choose 'Secondary Horizontal' for the axis title, then click on the title that appears and type 'Year' for the title of the horizontal axis.

That's it! You've created a semi-log graph in Excel. This type of graph is particularly useful when you want to visualize data that spans several orders of magnitude, providing a more comprehensive view of your data's trends.

Remember, the key to effective data visualization is to choose the right graph type for your data. Semi-log graphs are not suitable for all types of data, so always analyze your data first to determine the best way to represent it.

Now, go ahead and experiment with your own data. Happy graphing!