Change overlap of 2 columns on 2 axes

[Guest]

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]

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

 

[Guest]

Is there a way to just change the graph without having to start over. My
dataset is pretty complicated.

 

[Andy Pope]

You could try this,

Go to the Source Data dialog and Add 2 new series. The will have a value
series of ={1} , which you can change to ={0} after formatting.

Select one of the newly added data series and move to secondary axis.
Repeat for the valid data series you want on the right of each cluster.
If the columns are not how you want use the Series Order option on one
of the data series on the secondary axis to switch left/right position.

Cheers
Andy

 

[Guest]

That did it, Thanks!

You could try this,

Go to the Source Data dialog and Add 2 new series. The will have a value
series of ={1} , which you can change to ={0} after formatting.

Select one of the newly added data series and move to secondary axis.
Repeat for the valid data series you want on the right of each cluster.
If the columns are not how you want use the Series Order option on one
of the data series on the secondary axis to switch left/right position.

Cheers
Andy