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

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?

-

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.

-
This does seem to succeed in getting the axis back where I want it; thanks for that, but I would prefer to still have the axis labels be in this order if possible. Do you know of any way to get the axis back on the left side without changing the order? – nhinkle Apr 11 '11 at 7:12
@nhinkle: Yes, reversing the series doesn't fully solve the problem. I have edited my solution. – Mike Fitzpatrick Apr 11 '11 at 8:25
Ah, there we go! Thank you very much. – nhinkle Apr 11 '11 at 8:29

I always use a ridiculously small value for a minimum "crosses at" value, so that changing data doesn't again shift the axis. In this case, something like 1E-100.

-

you can set the crossing point of the axis

For your data set, set Vertical axis crosses = 0.00001

-