3
2
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?
nhinkle
Posted 2011-04-11T06:47:11.297
Reputation: 35 057
4
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.
Mike Fitzpatrick
Posted 2011-04-11T06:47:11.297
Reputation: 15 062
2
you can set the crossing point of the axis
For your data set, set Vertical axis crosses = 0.00001
chris neilsen
Posted 2011-04-11T06:47:11.297
Reputation: 4 005
1
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.
Jon Peltier
Posted 2011-04-11T06:47:11.297
Reputation: 3 470
1This 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 – 2011-04-11T07:12:14.690
@nhinkle: Yes, reversing the series doesn't fully solve the problem. I have edited my solution. – Mike Fitzpatrick – 2011-04-11T08:25:33.580