Many a times the data we have starts with small numbers and then it also has some large numbers. In such a scenario, it becomes difficult to plot them in a chart.
The solution is to use a logarithmic scale instead of a standard linear scale. A logarithmic scale allows your axis to jump from 1 to 10, to 100 to 1000 and so on without changing the spacing between axis points. In other words, the distance between 1 to10 is the same as the distance between 100 and 1000.
To change the vertical axis of a chart to logarithmic scale, follow below steps:
1) Click anywhere on the chart. This will open the Chart tools tab on the ribbon
2) Select the layout tab found under the charts tools sub tab
3) Click the Axis button and select primary vertical axis
After changing the the vertical axis to Logarithmic scale, the chart will look something like below: