Re: excel chart - primary and secondary x-axis

  • Thread starter Thread starter Andy Pope
  • Start date Start date
A

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.

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

--

Cheers
Andy

http://www.andypope.info
 
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
 
Hi Jon,

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

Jon said:
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top