+ Reply to Thread
Results 1 to 2 of 2

Need help on Ocean Current Stick Plots

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need help on Ocean Current Stick Plots

    I need to compile a series of plots that will display ocean current data over a period of time and depths. I have the following Fields:

    Date (DD.HH.MM)
    Depth (ft)
    Speed (knots)
    Direction (degree 0-360)

    The goal is to create a display like the one attached (or with same idea), with depth on the Y-axis, Date/time on the x and at each depth&time, there will be a vector with magnitude of "speed" and points in the direction of "direction".

    I hope someone can help. THANKS!




    42363_5day.png

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help on Ocean Current Stick Plots

    It's possible put you would need to calculate and build all of the xy pair values for each data point.

    You would use a xy-scatter, a series for each speed band. You would need to calculate the start and end position of the line based on the depth/time and speed/direction vector.

    In order to get all the individual vector arrows you would need to include a gap between xy pairs so you may find the easiest way to do this is via code. Especially if you need to produce a chart daily.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1