A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 14th, 2009, 04:50 PM posted to microsoft.public.excel.charting
Wei Wei
external usenet poster
 
Posts: 2
Default 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  
Old November 14th, 2009, 07:46 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 4,085
Default 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  
Old November 14th, 2009, 09:28 PM posted to microsoft.public.excel.charting
Wei Wei
external usenet poster
 
Posts: 2
Default 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  
Old November 15th, 2009, 12:07 AM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.