Hi all, i am hoping you can
help me. I am a recent convert to Excel 2007 and have a query. I am
trying to format a graph i have created, and to simplify, i have a line
graph with 2 sets of values, one between 0 and 300000, the other between
0 and 1, both against values of time on the X axis. Now, i would like
to have the line of values between 0-300000 on the primary Y axis, and
0-1 on the secondary Y axis. I would then like the first line (0-300000)
to be in front of the second line (0-1) on the graph. I cannot find a
way to do this, as whenever i try, the line of the secondary axis is
ALWAYS in front of the primary axis.
Is there a way to do this? I hope my probelm is clear enough to help, if
not, ask and i'll elaborate.
Thanks in advance