Problem with Column Chart on 2 Axis
 

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.

Problem with Column Chart on 2 Axis
 

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.

Problem with Column Chart on 2 Axis
 

Here's an illustrated example:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"HEK" wrote in message
...
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.