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. Click and drag your cursor to highlight ...

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." Fill in both columns of the ...