How do you make charts when you have lots of small values but few extremely large values?

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

4) Click the show Axis with Log Scale option

After changing the the vertical axis to Logarithmic scale, the chart will look something like below:

I am sure you would have encountered such kind of data once in a while. How do you go about charting then? Share your ideas and implementations using comments.

1 Comment

Leave a Reply

Your email address will not be published.