I am trying to plot two data series in a column chart on two different
vertical axis in Excel 2007. I used to do this all the time in 2003 but I am
having trouble with 2007. My chart type is the 2D clustered column...although
I've tried other types and run into the same problem. When I select the 2nd
data series and click "format data series" and then select the botton for
"plot series on a secondary axis" my chart then becomes a stacked column. I
want the two series to stay next to each other so I can compare them.

This is very frustrating. I walked through the help menu within 2007 and it
did not provide a solution either.

What am I doing wrong?