![]() |
Graph with two scales - calling a graph expert !
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 |
Graph with two scales - calling a graph expert !
a good start is to look in Jon Peltier's site:
http://www.geocities.com/jonpeltier/...rts/index.html |
All times are GMT +1. The time now is 01:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com