"Create Semi-Log Graph on Excel: Step-by-Step Guide"

Walter Jul 15, 2026

Creating a semi-log graph in Excel can be quite useful when you want to analyze data where one axis spans multiple orders of magnitude. This type of graph displays data with one logarithmic axis and one linear axis. Let's guide you through the process with this step-by-step tutorial.

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

Before we begin, ensure you have Microsoft Excel installed on your computer. This guide applies to Excel 2010 and later versions.

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

Preparing Your Data

First, let's organize your data in Excel. Supposing you have data in columns A and B, with A containing your independent variable (e.g., time in days) and B containing your dependent variable (e.g., sales amounts).

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

Name the headers as 'X Values' and 'Y Values' respectively. Keep your data clean with no blanks or null values, as Excel uses these to determine the scale of your graph.

Formatting Your Cells

Semi Log Graph In Excel
Semi Log Graph In Excel

Before creating the semi-log graph, format your cells appropriately. Select the range containing your data (e.g., A2:B100), then go to the 'Home' tab. Click on the ' formato2% cells' button and choose 'Number' > 'Currency'. This ensures Excel recognizes your data correctly.

Formatting the X-axis

Since the X-axis will be linear, no specific formatting is needed for the independent variable. Keep it as is.

A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel

However, for the Y-axis, which will be logarithmic, we'll need to format your data accordingly. Once again, select the range containing your Y-values (e.g., B2:B100). In the Number section, choose 'More Number Formats' > 'Custom'. Enter a number format like #.##E+0, then click 'OK'.

Creating the Semi-Log Graph

Now, let's create the semi-log graph. Select your data range, go to the 'Insert' tab, and click on 'Scatter' > 'Scatter with Smooth Lines and Markers'. Right-click on the graph and select 'Add Data Labels'. Click on the data labels, then click on 'Right aligned text' in the 'Format Selection' group on the 'Design' tab.

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

Finally, adjust your graph's layout. Right-click on the graph and select 'Format Selection' > 'Chart Elements' > 'Axis'. Here, you can adjust the maximum and minimum bounds and change the tick-mark values. For the Y-axis, choose 'Logarithmic Scale' from the Axis Options section.

Congratulations, you've just created a semi-log graph in Excel! This guide should help you create engaging and insightful graphs for your data analysis needs. Now that you have the basics down, feel free to explore Excel's various graph types to find the perfect visual representation for your data.

How to Create Log and Semi-Log Graphs in Excel
How to Create Log and Semi-Log Graphs in Excel
How to Plot Log Log Graph in Excel (2 Suitable Examples)
How to Plot Log Log Graph in Excel (2 Suitable Examples)
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
How to Use Graph or Chart in Excel Google Sheets
How to Use Graph or Chart in Excel Google Sheets
Noob to Excel Pro
Noob to Excel Pro
How to Create a Chart Template in Microsoft Excel
How to Create a Chart Template in Microsoft Excel
Progress Tracker in Excel‼️ #excel
Progress Tracker in Excel‼️ #excel
Excel graph
Excel graph
How to Make a Chart in Excel
How to Make a Chart in Excel