To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data" and highlight all entries in the single column.

How to Have Three Secondary Axes on Excel 2007. Excel 2007's secondary axis feature enables you to view two different data series with two distinct scales, all on the same chart. Use this feature ...