Logarithmic Scale In Excel

In this lesson, you will learn what a logarithmic scale is, and how to use it with charts.

Sometimes it happens that the data in the chart are contained in a large range. In this case, the individual values significantly different from each other deteriorating chart transparency. Smallest values are invisible. I will show how to solve this situation. I prepared a sample table of sales data for log scale purpose..

Sales of Products

See how to create a chart in the case where the data in the graph differ significantly from each other. You must first insert a chart. Let’s insert a column chart.

Sales of Products column chart

As you can see, it is completely unreadable. Two of the product’s sales are so large that you can’t see the other columns. Log scale would solve the problem of visibility. So you need to format the data series. Click on the data series, right-click and choose Format Axis.

Format Axis

Dialog box appears. Check ‘Logarithmic scale’ check box and set ‘Base’ to 10.

Logarithmics scale and Base

See how this time will look like your chart. Take a look at the scale of Axis.

Scale of Axis

When using a logarithmic scale is easy to read chart. Clearly you see all the bars, although significantly different from each other numerical values.

At the end of the lesson little theory. Look at the scale of the data in the chart. Logarithmic scale meant that each additional level of data is greater than 10 times. Choosing a basis for choosing a logarithmic scale of 10, but you can also choose any other number in the range from 2 to 1 000.


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial