Column chart with 2 Y axis's

[Father Guido]

I have two Y axis, the secondary is 10x the primary in values. The 1
data series plotted against the secondary axis shows up right on top of
the 4 data series plotted against the primary axis. Is there some way to
avoid this, so all 5 data series appear side by side with no overlap?

Thanks!!!

Norm

PS Excel 2002 & WIndows 2000 Pro

Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good

 

[Tushar Mehta]

Plot the data series you want on the secondary axis not once but 5
times. Ensure all of them are on the secondary axis. Hide the first
four by double-clicking each, then from the Patterns tab set the border
and area to None.

You will also have to add one of the series on the primary axis over
again. Format the extra series the same way as described in the
previous paragraph.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office

 

[Father Guido]

Plot the data series you want on the secondary axis not once but 5
times. Ensure all of them are on the secondary axis. Hide the first
four by double-clicking each, then from the Patterns tab set the border
and area to None.

You will also have to add one of the series on the primary axis over
again. Format the extra series the same way as described in the
previous paragraph.

Thanks Tushar!

That idea sounds like it'll work fine.

Norm


Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good