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.

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.