Chart - Two Sets of data

[jasjohnston]

I have two sets of data I want to present on the same chart. The first set of numbers are all around 90, the second set are all around 12. I want to use a line graph where both lines are relatively close to each other. How do I have two different y axes so the lines on the graph are close to each other...ie not one line near the top of the chart and one near the bottom?

 

[Gerald Higgins]

Select the 2nd y axis for one of the series.
In Excel 2003, right click the series you want to put on the 2nd y axis, select Format Data Series, select Axis tab, select secondary axis.

Then, if necessary, adjust the scale max/min settings for one or both axes.