dual axis chart

  • Thread starter Thread starter steamboat
  • Start date Start date
S

steamboat

I am trying to chart two series of data using two bars on two scales. When
i place both series on the same scale, I get two bars side by side but when
I try to place one of the series on a secondary axis (scale), the two bars
overlap. If the value of the series on top is largest, the other value
can't be seen at all. How do I get side by side bars using to scales?


Sample innput data:

Country Population phone penetration

US 300 100%
Canada 150 90%
Russia 250 50 %

Charts should have US, Canada and Russia along the x axis with two bars over
each country name one showing pop working off left scale the other
penetration as a percent off the right scale.

(yes i know this data is not correct)
 
The closest I can ever get is by going to Custome Types in
the Chart Wizard, and selecting Line-Column on 2 Axes. I
tried to get two bars too, but it just won't work if
they're not on the same scale.
Greta
 
Back
Top