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 Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.