Re: excel chart - primary and secondary x-axis

[Andy Pope]

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.

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

 

[Jon Peltier]

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

 

[Andy Pope]

Hi Jon,

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

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

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

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

- Jon