Hi,

You need to add 2 dummy series to act as place holders.

Example data set in range A1:E4
B1: =Left C1: =DumRight D1: =DumLeft E1:=Right
A2: =One B2: =1 C2: =0 D2: =0 E2: =3
A3: =Two B3: =2 C3: =0 D3: =0 E3: =2
A4: =Four B4: =3 C4: =0 D4: =0 E4: =1

Start by creating a column chart on the range A1:E4
Set the 3rd and 4th series to the secondary axis.
Remove extra items from legend if required.

Cheers
Andy

Charles wrote:
I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis
plots. But the columns are overlapping and I can't see one set of data. I
don't want them stacked and changing the gap and overlap width doesn't seem
to do anything.

Suggestions?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info