Line charts usually only plot the closing prices ... These are the steps to create a line graph in Excel. Empty cell A1 before you make the line chart if you're using numeric labels.