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.

Learn how to plot coordinates and create straight line graphs to show the relationship between two variables. Also, plot graphs that contain a negative coefficient of x.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.