Y axis

[Guest]

I want to have a chart with 2 data sets and plotted against different y axis.
But exel 2007 is too buggy to let me keep my original chart type and won't
let me display it as separate bars; instead that have to be directly on top
of each other.

Any ideas?

 

[Andy Pope]

Hi,

This is not something new in 2007. Placing a column series on to the
secondary axis always covered the series on the primary axis.
Have a look at Jon's page on how to do columns on 2 axes.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy