superimposing graphs

[carrera]

I'm not sure if this is even an excel question, but it involves 3 graphs I
made in excel, so here goes.

My 3 graphs are based on different bases. Each graphs just one thing.

1 grahes in percentages from 0% to 25%
1 graphes a number of hours, ranging from 4 to 10, in crements of .25
1 graphes a number of jobs performed, from 150 to 300, in whole numbers

I want to create a graph, or superimpose one image on top of another, so
that the 3 lines can be seen. Basically so I can show how if 275 jobs were
performed and it took 6.5 hours, OT is 15%.....and showing how if it is
expected that more jobs are performed, OT would have been expected to go up,
but instead stayed the same, and the number of hour to perform each job went
down.

 

[ShaneDevenshire]

Hi,

You might check out a dual axis chart. Plot all three sets of number first.
Then pick the largest or smallest series on the chart and choose Format,
Selected Data Series, Axis, Secondary Axis.

If this doesn't suit your needs there are other tricky ways to handle it. I
think Jon Peltier has some examples - http://peltiertech.com/Excel/Charts/

 

[carrera]

I will check it out Shane.

Thanks

Hi,

You might check out a dual axis chart. Plot all three sets of number first.
Then pick the largest or smallest series on the chart and choose Format,
Selected Data Series, Axis, Secondary Axis.

If this doesn't suit your needs there are other tricky ways to handle it. I
think Jon Peltier has some examples - http://peltiertech.com/Excel/Charts/