Go to an empty cell, J1 for instance, and click on the (chart wizard) icon.

• Step 1 - Under Standard Types select Chart Type: XY (Scatter). Under Chart Sub-type select the first chart in the second row (scatter with data points connected by smooth lines). Hit Next.

• Step 2 - Under the Data Range tab, click on the (collapse dialog) icon. Highlight cells A5 through K70. Click on the (open dialog) icon. Make sure the Series In: Columns is selected.

  Under the Series tab, go to the box listing the different series. Remove from this list all blank series and all Horizontal Distances, leaving only the four elevation series on this list. Hit Next.

• Step 3 - Chart Options. Enter the titles, legend, etc. that you wish. The X axis is the horizontal distance and the Y axis is the beach elevation both have units of feet. It is recommended that the legend be placed at the bottom of the graph. Hit Next.

• Step 4 - Select Place Chart As New Sheet: Chart 1. Hit Finish.

To print the graph, go to File then Print Preview to make sure the graph looks right on the page. To make adjustments go to Setup. When the graph is ready, select Print.

To save the spreadsheet and graph, go to File, Save As and change the Save as type to Microsoft Excel Workbook.

Congratulations, you have just graphed the profiles for a beach in Ocean City, MD. At this point, you can refer back to the Bridge data tip for discussion questions and ideas, and for more links on related subjects.