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.

Scatter diagrams are used to explore patterns between two sets of data. The table shows the results of eight students' maths and science marks in an assessment. Construct a scatter graph that ...