• Click on Excel to open the program. • Enter all the depth data into the corresponding boxes on the Excel table. • Once you have entered all the data, highlight all your data by clicking in box A1 and dragging to J6 so that all of your data is highlighted. • Go up to the tool bar and click on "chart". • Scroll down to "surface" and click on the view you prefer. • Fill in a chart title and label the x, y and z-axes. The z-axis is the depth. • To rotate the graph to get a better view of it, go up to the tool bar and click on "chart". • Scroll down to "3-D view" and play with the elevation and perspective until your seafloor is easy to see. • To be consistent with standard oceanographic graphs you will need to reverse the order of numbering on the depth axis. Generally the top of the graph is sea level and depth increases as you go down. To change that on the depth axis move the cursor over to the depth axis and right click. Scroll down to "format axis". Click on the "scale" tab. Check the box that reads, "values in reverse order". • To get more definition in your depth scale, change the major unit to 300 (or whatever works for you). These changes are made in the same "format axis", "scale" section as above. • Once you are satisfied with your graph, you can print it out. (See an example of a 3-D plot below.)  |
