View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Roxy Roxy is offline
external usenet poster
 
Posts: 45
Default primary/secondary axis next to each other

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