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  

excel chart - primary and secondary x-axis



 
 
Thread Tools Display Modes
  #1  
Old September 22nd, 2003, 02:01 PM
KEN LAU
external usenet poster
 
Posts: n/a
Default excel chart - primary and secondary x-axis

please advise how to exchange these 2 axis so that the
secondary x-axis will appear on the left side.
  #2  
Old September 22nd, 2003, 02:31 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default excel chart - primary and secondary x-axis

Hi Ken,

To change the sides the axis are displayed on.
Select secondary axis
right click and format object
on Patterns tab set Tick Mark Labels to Low.
Select Primary axis and repeat but this time set to High.

Not this does not effect the actual tick marks's.
Either remove them, use major/minor values to compenstate or use
additional dummy series to create you own.

KEN LAU wrote:

please advise how to exchange these 2 axis so that the
secondary x-axis will appear on the left side.


--

Cheers
Andy

http://www.andypope.info

  #3  
Old September 22nd, 2003, 05:21 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default excel chart - primary and secondary x-axis

Actually, you can move switch the positions of both axes, but you move
the X axes by formatting both Y axes. Double click each Y axis, change
the "Crosses at maximum" option from checked to unchecked or from
unchecked to checked.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:
Hi Ken,

To change the sides the axis are displayed on.
Select secondary axis
right click and format object
on Patterns tab set Tick Mark Labels to Low.
Select Primary axis and repeat but this time set to High.

Not this does not effect the actual tick marks's.
Either remove them, use major/minor values to compenstate or use
additional dummy series to create you own.

KEN LAU wrote:

please advise how to exchange these 2 axis so that the secondary
x-axis will appear on the left side.




  #4  
Old September 22nd, 2003, 10:32 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default excel chart - primary and secondary x-axis

Hi Jon,

I notice this approach also keeps the tick marks with the labels.
Much neater.

Jon Peltier wrote:
Actually, you can move switch the positions of both axes, but you move
the X axes by formatting both Y axes. Double click each Y axis, change
the "Crosses at maximum" option from checked to unchecked or from
unchecked to checked.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:

Hi Ken,

To change the sides the axis are displayed on.
Select secondary axis
right click and format object
on Patterns tab set Tick Mark Labels to Low.
Select Primary axis and repeat but this time set to High.

Not this does not effect the actual tick marks's.
Either remove them, use major/minor values to compenstate or use
additional dummy series to create you own.

KEN LAU wrote:

please advise how to exchange these 2 axis so that the secondary
x-axis will appear on the left side.






--

Cheers
Andy

http://www.andypope.info

  #5  
Old September 26th, 2003, 11:20 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default excel chart - primary and secondary x-axis

Yep, this way actually moves the entire axis, labels, tick marks, and all.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:
Hi Jon,

I notice this approach also keeps the tick marks with the labels.
Much neater.

Jon Peltier wrote:

Actually, you can move switch the positions of both axes, but you move
the X axes by formatting both Y axes. Double click each Y axis,
change the "Crosses at maximum" option from checked to unchecked or
from unchecked to checked.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:

Hi Ken,

To change the sides the axis are displayed on.
Select secondary axis
right click and format object
on Patterns tab set Tick Mark Labels to Low.
Select Primary axis and repeat but this time set to High.

Not this does not effect the actual tick marks's.
Either remove them, use major/minor values to compenstate or use
additional dummy series to create you own.

KEN LAU wrote:

please advise how to exchange these 2 axis so that the secondary
x-axis will appear on the left side.







 




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 12:20 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.