Excel effectively treats the two series as two independent charts. If you
still want the series side by side, make dummy series and make these
transparent without borders so you don't see it effectively. Change the
series order as appropriate.
GL,
Henk

"headly" wrote:

I have two series, A and B, and 3 values for each series. When I create a
side by side column chart, right click the second series and choose Format
Data Series Axis Secondary the two series overlap in one space; why did I
lose the side by side appearance and how might I get it back? TIA for any
ideas.