Open Excel and create a new spreadsheet. Enter the standard samples you are graphing into cells "A1" and "A2." For example, enter "Concentration" and "Absorbance." ...

How to make a line graph in Excel. 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2.

To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart. Select the appropriate line chart.