Graphing the Data

Now that you have the relevant data in the right format, you can create a scatterplot graph of the earthquake locations superimposed on a map of the world. To do this, highlight the Latitude and Longitude columns and select the Chart Wizard icon.

For chart type, choose "XY (Scatter)" and select Next.

Click on the Series tab. The default value is to set the first column of data from the left as the X-values (Column D in this example), and the next column as the Y-values. For this graph, you will need to reverse the order of those settings. Set the longitude column as your X-Values and the latitude column as the Y-Values.

Click Next, give the graph a title, and label each axis. Turn off the legend and click on Next. Save as a new chart. Your graph will look something like this, but it's still not ready to be superimposed on the world map.

Procedure 1  |   2  |   3   |   4  |   5  |   6  |