2 Axis Column Chart

[dguilbault]

I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis
to be a line, but can't figure out how to do this with a column.

 

[Andy Pope]

Hi,

You need to stagger your data to stop the 2 sets of columns overlapping
each other.
See here for information.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Kristin C]

I have worked out how to do it but unfortunately my two columns sit over/in
front of/behid each other rather than side by side.

 

[Jon Peltier]

Andy seems to have copied the wrong link. Try this:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[Andy Pope]

Doh!

Thanks Jon. I have also posted the correct link to the other post I have
used it in.

Cheers
Andy