Figure 2: Scatter plots showing various relationships between two variables and their corresponding Pearson correlation coefficients, r. Credit: Technology Networks.

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.