How and Why you should use a Logarithmic Scale in an Excel Diagram

Look at the diagrams below – they show the same numbers, but the vertical scales, the y-axis, are different. In this example we see how $1,000 grows to almost $300,000 in 50 years with a 12% yearly return.

The blue diagram has a linear scale on the y-axis, so the distance between 0 and 50,000 is the same as the distance between 200,000 and 250,000. The yellow diagram has a logarithmic scale with base 10, which means that each interval is increased by a factor of 10. Read more to find out how to do this in Excel, and why you may or may not want to use a logarithmic scale:

READ MORE