Column chart with 2 Y axis's

  • Thread starter Thread starter Father Guido
  • Start date Start date
F

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
 
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
 
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.
Click to expand...

Thanks Tushar!

That idea sounds like it'll work fine.

Norm


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