How to Graph Tide Data on Excel 2007

Written by matthew weeks | 13/05/2017
How to Graph Tide Data on Excel 2007
Tidal flows can be expressed in Excel by a scatter plot with a smoothed curve. (Jupiterimages/Comstock/Getty Images)

Tidal curves are charts that show the daily times and heights of the high- and low-water marks for a particular location, along with all of the heights in between, expressed in the form of a smoothed curve. They are used by mariners and fisherman to determine both the safe times to leave and enter port along with the ideal times to begin fishing. You can create a tidal curve in Microsoft Excel with just a few clicks of the mouse.

Create a new worksheet in Excel. Enter column headings for the time of day and the height of the tide.

Populate the columns with all of your available data.

Click on the Chart Wizard button in the tool bar at the top of the screen. Select a Scatter Plot with Smooth Lines and Markers. Click on the Finish button. You will have the best approximation of the tidal curve based on the data you entered.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.