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?

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Martin" wrote in message
...
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?