Excel Chart: Adding 2nd Axis turns to Stacked Columns

[Earth]

Hi
I am trying to build a very simple Excel chart, with two data series. I want it to be a simple column chart, but with the series plotted on separate axis.

What's happening is:
I build the chart as a column graph. I right click Series2 -> Format Data Series -> Axis (tab), and select "Secondary Axis" -> OK.

The chart then converts from a normal column graph (with columsn side by side), to what looks like a stacked column graph, but is in fact the columns overlaid on top of each other.

I've tried various ways of getting around this, but am not having any luck.

Can anyone offer any advice?

Thanks in advance
Earth

 

[SkipVought]

Earth,

If you format any series, activate the Options Tab, play around with the Overlap and Gap Width properties

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]