Secondary Axis

[doublediamond111]

I have two different Series and on two Y Axis, but for some reason they stack on top of each other, instead of next to each other. How can I get them to stack next to each other?

 

[texasalynn]

change the chart type to "Column - Cluster Column"

 

[doublediamond111]

It doesnt work even as clustered. It just stacks Series 1 and Series 2 on top.

 

[texasalynn]

have you tried the column - 3D column?

 

[doublediamond111]

when i do that it wont let me add a secondary axis

 

[texasalynn]

ok so maybe we need to take a step back. The suggestion I gave were from my thinking you go to the chart you have created and try changing the chart type. (Right click on the chart and select "chart type")

 

[doublediamond111]

nope, it seems like you can add secondary axis with 3D graphs for some reason.

 

[texasalynn]

take a look at Peltier site - he has some great solutions of charts

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