move y-axis to the left of x-axis "0"


Wei Wei

Hello, Please help me move y-axis out of "0" along x-axis (left) without
changing the x-axis minimum and major unit. I try this just because the
overlapping of error bar with y-axis at "0".

Bernard Liengme

You need to format the y-axis and specify where it crosses the x-axis
Next time tell us what Excel version you are using - then we can be more
best wishes--
Bernard Liengme
Microsoft Excel MVP

Wei Wei

Hi, Bernard,

Thank you for your fast response.
I am using office 2007
My time-course experiment is 0, 4, 8, 10, 12, 16 hours.
I set x-axis:
Major unit=4
Minor unit=2
Vertical axis crosses=0
Got X-axis label=0, 2, 4, 6, 8, 10, 12, 14, and 16. And the Y-axis crosses
at 0. This is NOT what I want because the error bar at 0 hour overlaps with
Yes, I can format the vertical axis cross at -1.
Minimum=-1 (If =0, Y-axis doesn’t move to -1 position)
Major unit=4
Minor unit=2
Vertical axis crosses=-1.
Got Y-axis is 1 unit away from the start time point (0). But the X-axis
label=-1, 1, 3, 5, 6, 7, 9, 11, 13, and 15, not 0, 2, 4, 6, 8, 10, 12, 14,
and 16.
Does this process need special code?

David Biddulph

You could set minimum to -2 instead of -1, or set minor unit to 1 instead of

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question