column charts on two axis

[Guest]

I am trying to show a column chart on 2 axis. I have chosen the combination
line and column chart to get the 2 axis but when I change the line to a
second column it puts the columns over the top of the first axis columns. How
do I get them to be side by side?

 

[Bernard Liengme]

Have a look at: http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes

 

[Guest]

Fantastic. Thanks

 

[Julie]

I am trying to show a column chart on 2 axis. I have chosen the combination
line and column chart to get the 2 axis but when I change the line to a
second column it puts the columns over the top of the first axis columns. How
do I get them to be side by side?

 

[Jon Peltier]

You need to use dummy series with no plotted values to move the visible
series to either side:

Columns on Two Axes
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon