Excel – Logarithmic X-axis in Excel puts axis numbers in wrong position

chartsmicrosoft excelmicrosoft-excel-2010

I have a dataset with logarithmic x-values (of concentration being diluted by a factor of 10) and regular (non-logarithmic) y-values. When I format the x-axis to use a logarithmic scale, the y-axis is displayed on the right side of the graph instead of the left side of the graph like it is supposed to be. What causes this, and is there any way I can put the y-axis back in its proper position?

broken axis

Best Answer

Why? Because your concentrations are less than 1 so the logarithms are negative values.

To fix, format the x-axis and select Vertical axis crosses: Axis value and supply a value smaller than your minimum x-axis value.

Related Solutions

Excel automatic axis scale completely inappropriate for data

Have you tried right-clicking the X-axis, and doing 'Format Axis...'? Maybe you should override an 'auto' value and use your own constant. After double-checking the data (including the cell formatting) I would try this.

Excel – Zero values in Excel logarithmic chart: Can the warning be suppressed

A workaround but I would install AutoHotkey and set it to immediately dismiss that dialog when it appears: http://www.autohotkey.com/docs/commands/SetTimer.htm

; Example #1: Close unwanted windows whenever they appear:
#Persistent
SetTimer, CloseMailWarnings, 250
return

CloseMailWarnings:
WinClose, Microsoft Excel, Negative or zero values cannot be plotted
return

You'll soon think of 50 windows and dialogs you'd like to close as soon as they appear so the initial effort to install it and set it up will soon pay off.

Best Answer

Related Solutions

Excel automatic axis scale completely inappropriate for data

Excel – Zero values in Excel logarithmic chart: Can the warning be suppressed

Related Question