Histogram with 2 axis

Hi,

In a histogram chart type, I have several countries on the x axis and
two rectangles for each country giving their gdp and gdp per capita
level.

What I want to do is assign gdp to the left Y-axis and gdp per capita
to the right Y-axis.

Usually, I just change the data series option so it assign it to the
secondary axis.

However, when I do this in an histogram, excel also automatically
group the two rectangles together for each country.

Does anyone knows how to avoid that ?

I'm using office XP.

Thanks a lot for your help!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/