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.

Constructing a Line Graph . Line graphs are drawn on two axes: the x-axis (horizontal) and the y-axis (vertical). Each axis represents a different data type, and the point at which they intersect ...

To create a line graph: Look for the largest frequency in your table. Draw a vertical axis close vertical axis The line on a graph that runs vertically (up-down) from the origin.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.