Making a log scale in Excel is a great way to visualize data with a wide range of values. It’s simple to do: just select your data, go to the ‘Format Axis’ option, and choose the ‘Logarithmic scale’ box. This will instantly transform your chart to a log scale, making it easier to interpret data that varies exponentially.

You want to create an Excel Chart Logarithmic Scale! You can use the logarithmic scale Excel (Excel log scale) in the Format Axis dialogue box to scale your chart by a base of 10. When you have a large numerical range of data and you want to plot a graph, you will most probably end up with a skewed looking chart like the one below.

Click on the axis you want to convert to a log scale (usually the Y-axis). If you want to log-transform the X-axis, click it instead. Right-click on the selected axis. Choose Format Axis from the context menu. A sidebar or dialog box will appear. Look for the Axis Options section. Check the box labeled Logarithmic scale.

Although less practical, the logarithmic scale option is available for the horizontal axis in Excel, too. A logarithmic scale on the X-axis is less common in general business or data analysis. The horizontal axis usually involves categories, time, or other linearly increasing quantities.