I recently installed Office 2007 and my charts that have a primary and
secondary vertical axis now has the secondary axis just to the left of the
primary. I hope thats not how 2007 is suppose to look. How can I get hte
secondary axis back over to the right of the chart?

Hi,

I was able to reproduce the problem if the chart had a secondary x axis
as well as secondary y axis, but only when the secondary x axis had the
option Categories in reverse order.
To send the secondary Y axis back to the right I set Vertical axis
crosses at to automatic instead of maximum.

Cheers
Andy

Roxy wrote:
I recently installed Office 2007 and my charts that have a primary and
secondary vertical axis now has the secondary axis just to the left of the
primary. I hope thats not how 2007 is suppose to look. How can I get hte
secondary axis back over to the right of the chart?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy,

Thanks for the reply and help. Unfortunately my chart does not have a
secondary horizontal axis (or at least it is set to None under Layout, Axis).
The 3 other axis are all set to auto under the axis options and none of them
has the values in reverse order checked. If I create a new chart with the
data it turns out OK, but I am not going to like doing that for the 40 +
charts.

"Andy Pope" wrote:

Hi,

I was able to reproduce the problem if the chart had a secondary x axis
as well as secondary y axis, but only when the secondary x axis had the
option Categories in reverse order.
To send the secondary Y axis back to the right I set Vertical axis
crosses at to automatic instead of maximum.

Cheers
Andy

Roxy wrote:
I recently installed Office 2007 and my charts that have a primary and
secondary vertical axis now has the secondary axis just to the left of the
primary. I hope thats not how 2007 is suppose to look. How can I get hte
secondary axis back over to the right of the chart?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,

If you want to email me, off newsgroup, an example file I will see if it is
possible to sort out the axis without re creating new charts.

andy AT andypope DOT info

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Roxy" wrote in message
...
Andy,

Thanks for the reply and help. Unfortunately my chart does not have a
secondary horizontal axis (or at least it is set to None under Layout,
Axis).
The 3 other axis are all set to auto under the axis options and none of
them
has the values in reverse order checked. If I create a new chart with the
data it turns out OK, but I am not going to like doing that for the 40 +
charts.

"Andy Pope" wrote:

Hi,

I was able to reproduce the problem if the chart had a secondary x axis
as well as secondary y axis, but only when the secondary x axis had the
option Categories in reverse order.
To send the secondary Y axis back to the right I set Vertical axis
crosses at to automatic instead of maximum.

Cheers
Andy

Roxy wrote:
I recently installed Office 2007 and my charts that have a primary and
secondary vertical axis now has the secondary axis just to the left of
the
primary. I hope thats not how 2007 is suppose to look. How can I get
hte
secondary axis back over to the right of the chart?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info