Regardless, here is our guide to get you started on creating a scatter plot in the latest version of Excel and you can decide later if a different chart style is in order.

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.

How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.