Can you set dual axis side by side column charts?

[Shane Daniel]

I'm trying to create a column chart where the secondary axis is next to the
primary. Excel keeps making the 2 overlap, how do I make them set side by
side.

 

[Bernard Liengme]

This is so annoying but Jon has solved the problem, see
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes

 

[Shane Daniel]

Thanks, I didn't think about tricking excel, thats pretty cool.