Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

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.

share|improve this answer
1  
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
add comment

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.

share|improve this answer
add comment

you can set the crossing point of the axis

For your data set, set Vertical axis crosses = 0.00001

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.