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 Plots: Effective for showing the relationship between two variables. Use when you want to show how one variable affects another.