MrExcel.com - Your One Stop for Excel Tips & Solutions

OVERLAPPED Charts when using secondary Y axis

Posted by Andrew Zdanowicz on September 28, 2001 3:37 AM

Whenever I move a data series to a secondary Y axis, it overlays the other data series for the same X values. I've tried using "Overlap" and "Gap Width" in format options, but the best I come up with is to make the top series skinny and the underlying series fat so both can be seen. I'd like to completely do away with the overlap and have the data series lying side by side again. Any way to acomplish this??

Thanks,

Andy

Posted by Eric on September 28, 2001 6:10 AM

If I understand you correctly, change the x values for the series on the second Y axis

It sounds as if the data plotted on the two Y axes still share the same values on the X axis. You could try increasing the X values for the series plotted on the second X axis. For instance, if series 1 was plotted on X values 1 to 10, then series 2 could plot on X values 11 to 20.
Sorry if I missed your point.