column charts with 2 Axes in excel 2007 (overlapping columns)

[emanon132501]

Hi,

I have 2 sets of data. Data 1 is Customer satisfaction percentage and Data 2 is number of dissatisfied customer due to poor product knowledge of my employees.

In excel 2003 once i plot these i just have to assign 1 series as my secondary axis and the columns would be side by side. But in Excel 2007 it's driving me nuts both columns are overlapping. how do i make them go side by side?

Please help!

[Andy Pope]

Even in xl2003 placing column charts on 2 axes requires changing the layout of your data to prevent overlapping.

Check you '03 charts for data layout.

If still stuck post example of your '03 chart