Attached is an xlsx sheet with various metocean data for a data buoy. I would like to be able to analyse this data through use of dynamic charts for specific periods or dates and specific column headings eg windspeed , wave height etc. Can you please assist in how I may go about creating such dynamic charts so graphs presented more interactive and meaningful. The recorded data would be expanding so like capability to auto update as new data inserted in columns etc.
Finally is it possible to create output charts for all headings an say one dashboard like page for quick review for specified period say a year or month or even specific day??
I am using windows 7, office 2010.
Thanks in advance for assistance.