Thanks for the file. That helps. But it's not quite clear what data you want to chart.
You can create a chart that includes all rows of the data table and then use the Autofilter to filter the table to show only the "mooring" rows. Then the chart will only show those values, without any special Excel tricks.
Bookmarks