Logarithmic Scale in Excel: Mastering Semi-Log Graphs

Walter Jul 15, 2026

When working with data in Excel, you might find that some values vary over a significant range, making it challenging to visualize or compare them accurately. This is where semi-log scales come in handy. A semi-log scale, also known as a semi-logarithmic scale, combines features of linear and logarithmic scales to present data in a more comprehensible manner. Let's delve into how to create and interpret semi-log graphs in Excel.

a truck log sheet with the words truck log on it
a truck log sheet with the words truck log on it

Before we dive into creating semi-log graphs, let's understand why they're useful. A semi-log graph displays one axis on a linear scale and the other on a logarithmic scale. This is particularly useful when one set of data spans many orders of magnitude. For instance, you might use a semi-log scale to plot the growth of a company's revenue over time, as the early years' revenue might be considerably lower than later years, making a linear scale less informative.

Free Printable Mileage Log Template (Excel, Word)
Free Printable Mileage Log Template (Excel, Word)

Creating a Semi-Log Graph in Excel

Excel provides a convenient way to create semi-log graphs through its chart creation interface. Here's a step-by-step guide:

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets

First, ensure your data is arranged in a table format. For this example, let's assume you have data in columns A and B, where A contains years (2010 to 2020) and B contains the corresponding revenues (values ranging from 100,000 to 1,000,000).

Manual Formatting

Free Printable Vehicle Maintenance Log Templates [Excel, Word, PDF]
Free Printable Vehicle Maintenance Log Templates [Excel, Word, PDF]

If you prefer manually setting the scale, select your data and click on 'Insert' in the Excel ribbon, then choose the type of graph you want (e.g., line graph). A new chart will appear. Right-click on the axis you want to format (left or bottom), and select 'Format Selection'. In the pane that appears, under 'Axis Options', you can change the 'Axis type' to 'Logarithmic' for the desired axis. Make sure to uncheck 'Automatic' under 'Minimum' and 'Maximum' to adjust the range.

However, manually adjusting the scale can be tedious. Excel's automatic scaling feature generally provides reasonable default values, so you may not need to adjust it unless you have specific reasons to do so.

Using the Scatter with Smooth Lines and Markers (SXY) Chart

Log Status Template in Excel, Apple Numbers, Pages, Google Sheets, Word, PDF, Google Docs - Download | Template.net
Log Status Template in Excel, Apple Numbers, Pages, Google Sheets, Word, PDF, Google Docs - Download | Template.net

For more advanced control over your semi-log graph, use the Scatter with Smooth Lines and Markers chart. This type of chart allows you to change one axis to a log scale without affecting the other. Here's how to create one:

Select your data and click on 'Recommended Charts' in the Insert tab. Choose a scatter chart from the suggestions, then click on the 'Use Original Data Source' button. Now, follow the same steps as above to format the axis as logarithmic. The other axis will remain linear, creating a semi-log chart.

Interpreting Semi-Log Graphs

Vehicle Log Book | Excel Templates
Vehicle Log Book | Excel Templates

On a semi-log graph, the logarithmic axis is typically the vertical one, displaying values like quantities, measurements, or time in a logarithmic scale. This means each division along this axis represents a tenfold increase or decrease, making it easier to compare values spanning many orders of magnitude.

_selector

How to Create Log and Semi-Log Graphs in Excel
How to Create Log and Semi-Log Graphs in Excel
Free Excel Leave Tracker Template (Updated for 2026)
Free Excel Leave Tracker Template (Updated for 2026)
How to Create Log and Semi-Log Graphs in Excel
How to Create Log and Semi-Log Graphs in Excel
141 Free Excel Templates and Spreadsheets | MyExcelOnline
141 Free Excel Templates and Spreadsheets | MyExcelOnline
Sample Software Log Template in Apple Numbers, Word, Excel, Apple Pages, Google Docs, Google Sheets - Download | Template.net
Sample Software Log Template in Apple Numbers, Word, Excel, Apple Pages, Google Docs, Google Sheets - Download | Template.net
a mileage log is shown in the form of a blank sheet for employees to use
a mileage log is shown in the form of a blank sheet for employees to use
Excel TMP
Excel TMP
Project Submittal Log Excel Template with Automated Dashboard
Project Submittal Log Excel Template with Automated Dashboard
📋 Calendar + Task Tracker + Time Log #excel
📋 Calendar + Task Tracker + Time Log #excel