column charts on two axis
 

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?

column charts on two axis
 

Have a look at: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jo" wrote in message
...
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?

column charts on two axis
 

Fantastic. Thanks

"Jo" wrote:

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?

column charts on two axis
 

"Jo" wrote:

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?

column charts on two axis
 

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/...OnTwoAxes.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Julie wrote:

"Jo" wrote:

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?