Click on the graph axis you want to change to a logarithmic scale. Note that by clicking on different parts of the chart, you can select the whole chart, the plot area only, the legend or each axis.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

In “ When Should I Use Logarithmic Scales in My Charts and Graphs ”, I showed the revenues of the top 60 Forbes 500 companies using both linear and logarithmic scales. The log scale spread out ...