View Single Post
  #1  
Old October 14th, 2003, 01:36 AM
Fx_D@v
external usenet poster
 
Posts: n/a
Default 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/