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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|