Scattergraphs are a way of plotting what is called bivariate data. This is data that is related but there is still a bit of variety in what is presented. There are two videos here. One to quickly show how Excel can make a tidy graph of the data and one where you need to think about your scale and axes before you start plotting the points.