If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

Scatter charts use two columns of data for each point. By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis ...