Excel offers various chart types, but a line chart is the best choice. Select the two columns containing the known Ys and the new Ys. In this spreadsheet, these will be columns B and C .