You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

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.

Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet. For example, if you are comparing the stock performance of two ...