Outrageous Excel Change Chart To Logarithmic

Heres how to change the x-axis to logarithmic in Excel.

Excel change chart to logarithmic. Change the chart type. Value is 1 10 100 and your major minor units must be multiples of 10. Excel 2010 or 2007 In your XY scatter graph right-click the scale of each axis and select Format axis.

In the Scale tab select the Logarithmical Scale option and click ok. See screen shot below. Last edited by richierocks.

If you are in Excel 2010 or 2007 it will open the Format Axis dialog. Alternatively you can right-click on a number and choose Format Axis. To verify that the data was imported properly select the X and Y column then create a scatter chart.

In this case the first column is Cuba and the last is Barbados so the columns match the order of the source data moving moving top to bottom. Here the axis ranges from 8 to 80 still a decade on the base 10 log scale. You can however customize the scale to better meet your needs.

LOG function in excel is used to calculate the logarithm of a given number but the catch is that the base for the number is to be provided by the user itself it is an inbuilt function which can be accessed from the formula tab in excel and it takes two arguments one is for the number and another is for the base. To create a log-log graph follow the steps below for your version of Excel. By default Microsoft Excel determines the minimum and maximum scale values of the value y axis in a chart.

When Excel plots data in a column chart the labels run from left to right to left. This tutorial shows how to draw a log curve Learn more. Instead of the minor ticks being located at multiples of ten 20 30 40 50 they are located at multiples of 8 16 24 32 40 We can also change the maximum so that the axis spans a non-integral.