If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
move y-axis to the left of x-axis "0"
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". |
#2
|
|||
|
|||
move y-axis to the left of x-axis "0"
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 specific best wishes-- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Wei Wei" wrote in message ... 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". |
#3
|
|||
|
|||
move y-axis to the left of x-axis "0"
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: Minimum=0 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 Y-axis. 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? Thanks. "Bernard Liengme" wrote: 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 specific best wishes-- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Wei Wei" wrote in message ... 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". . |
#4
|
|||
|
|||
move y-axis to the left of x-axis "0"
You could set minimum to -2 instead of -1, or set minor unit to 1 instead of
2. -- David Biddulph "Wei Wei" wrote in message ... 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: Minimum=0 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 Y-axis. 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? Thanks. "Bernard Liengme" wrote: 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 specific best wishes-- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Wei Wei" wrote in message ... 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". . |
Thread Tools | |
Display Modes | |
|
|