Problem with Column Chart on 2 Axis

H

headly

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.
 
H

HEK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column charts with set set of data 0
Chart data scrunches to left when adding X axis date series 0
Using the full width of an Excel chart with two Y-axes 2
Custom Format numbers for learning chart 0
Moving overlapping bars forwards and backwards 1
sideways stacked bar charts with line series on the same axis 0
Overlaying 2 Data Series with Different Time (X) Axis 3
One extra x axis item that wont go away - can anyone help? 3

Top