Overlapping Bars Chart & Two Y Axes: how?
 

I can create bar and column charts w/ 2 data sets slightly overlapping.
However, when I add a secondary Y axis, the two sets of bars completely
overlap w/ no offset possible -- at least not that I can figure out. Is
there a way to have my cake and eat it too, that is, have two Y axes and a
slight overlap of the bars?

Overlapping Bars Chart & Two Y Axes: how?
 

Hi,

You need to change the layout of your data in order to have column chart
with 2 axes.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Jay wrote:
I can create bar and column charts w/ 2 data sets slightly overlapping.
However, when I add a secondary Y axis, the two sets of bars completely
overlap w/ no offset possible -- at least not that I can figure out. Is
there a way to have my cake and eat it too, that is, have two Y axes and a
slight overlap of the bars?

--

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