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

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

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

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