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.

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.

But choosing the right chart isnt always straightforward. Let's break down the essential Excel chart types and how to use them effectively.

A line graph connects individual data points that reflect numerical values. It is used to visualize the relationship between dependent and independent variables.

They even use the dumb names that Excel uses for types of graphs. Only plot the X and Y values. I opted to not have data point labels and just had the line.