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.

Select More Commands to open the Excel Options dialog box. In the Choose commands from drop-down list, select All Commands. Scroll down to find the Form command, select it, and click Add.