Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
equations on appropriate graph scales | Excel Discussion (Misc queries) | |||
How do I add two vertical scales to a line graph? | Charts and Charting in Excel | |||
bar graph with varying Y scales | Charts and Charting in Excel | |||
how can i graph with log-log scales? | Charts and Charting in Excel | |||
how can i graph with log-log scales? | Charts and Charting in Excel |