Problem with Column Chart on 2 Axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top