Graph with two scales - calling a graph expert !

[Steve P]

Hi all,

I have the following graph:
- left vertical axis, showing absolute values
- bottom horizontal axis, showing months
- right vertical axis, showing percentages

The problem lies in scale of the right vertical axis. The
zero value ( o %) does not cross the horizontal axis at
the correct spot, even after indicating that it should
cross at zero (in the "Format axis" option).

In other words, in the scale of the left axis the
horizontal line crosses at zero, however in the scale of
the right axis it doesn't !

To correct this I need to go into each graph and adjust
the mininum, maximum, major & minor unit to such an extent
that the zero in scale hits the horizontal axis at the
right spot. Needless to say, this is a nightmare ...

Any help would be greatly appreciated.

Regards
Steve P

 

[Mika]

a good start is to look in Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Charts/index.html