+ Reply to Thread
Results 1 to 12 of 12

Multiple Wind Speed and Direction arrow plots on an xy scatter

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    Portsmouth, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Talking Multiple Wind Speed and Direction arrow plots on an xy scatter

    Hello

    I have a large list of wind speed and direction values for a fixed range of latitudes and longitudes taken over 8 weeks. I want to plot the wind and speed values as arrows (small arrow, low speed etc) on an x y scatter chart overlayed on top of a map image.

    I have already configured a chart that plots the lat/long (converted the the lat/long to decimals etc) and plotted their positions on an xy chart with the image in the background. That was failry easy but now I'm looking for a way (a macro maybe) to replace the plotted points with an arrow that inidcates direction and speed. Ideally I would also want to show the speed and direction as a data label next to them.

    I came across the piedatamarkers.xls which uses a macro to replace the dots with pie charts (that are themselves configurable), credit to Andy Pope with http://andypope.info/charts/piedatamarkers.htm additionally his gauge chart on http://andypope.info/charts/gauge.htm shows a good way of rotating a variable length (representing wind speed) line according to angle (wind direction if it was an arrow) so it seems it is in the art of the possible. But I am afraid it is way beyond my intellect and talent. Willing to take a long path to enlightenment and learn but equally if anybody has any ideas or solved solutions it would be great.

    if you can imagine a weather forecast with arrows, thats the effect I'm looking for.

    Thanks in advance

    Surfy

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

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    You may find this example closer fits your problem.
    http://www.andypope.info/ngs/ng10.htm

    Else post an example workbook with an example, using shapes, of how some of the data should look.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,601

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    This thread gives examples of generating a wind rose:

    http://answers.microsoft.com/en-us/o...8-785a4709d4e8

    It might give you another slant on it.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    06-07-2013
    Location
    Portsmouth, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Wink Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Thanks Andy and Pete

    Responding to Andy on this one. I have attached a dummy wind.xls. The whole data set is vast. 2 charts on it. The first is a version of NG10.HTM which I had made earlier, attached really in case there were any settings of interest, the right hand chart is what I want to achieve, directional arrows replace the data points and rotate/resize according to the wind speed and direction. Could also be useful to show different colours.

    For info I did see a forum post somewhere where a VB script had been writtent to rotate a wingdings arrow through 0 to 360 depending on a value set in a cell.

    The answers out there I'm sure Scully

    Nny further assistance would be appreciated.

    Surfy
    Attached Files Attached Files

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

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    this code will do it. I used a bubble chart to resize markers

    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-07-2013
    Location
    Portsmouth, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Andy that is fantastic and pretty much just what I was looking for. Thank you very much. I just had a quick play and the only thing that I would want to change is to set some conditional formatting for the colours in say increments of x knots. I just tried to see if the normal cell conditioning worked and it doesnt seem to so could you advise what I need to change in the script?

    Cheers

    Mike

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

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    You can use DisplayFormat to get the resulting fill colour from CF

    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    06-07-2013
    Location
    Portsmouth, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Andy

    Fantastic, I shall have a good play with this over the weekend.

    Best

    Mike

  9. #9
    Registered User
    Join Date
    09-24-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Hi i agree, very good excelchart, thats also what i needed, but is it possible to have 2 variables(two data sets), not only wind but also water flow which also have speed and direction?

    regards

  10. #10
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,601

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    You should not attempt to hijack someone else's post by asking your own questions - start a new thread instead, maybe with a link back to this one.

    Pete

  11. #11
    Registered User
    Join Date
    09-24-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Ok sorry for that.

  12. #12
    Registered User
    Join Date
    06-16-2014
    Location
    Yangon, Myanmar
    MS-Off Ver
    2010
    Posts
    1

    Re: Multiple Wind Speed and Direction arrow plots on an xy scatter

    Andy,
    I was interested in the same topic so looked at your code and setup. Had a bit of a problem with the arrow direction, until I remembered that winds are recorded "out of" a direction. My application is 180 degrees out. I am tracking what direction an intercept was on. Just reformatted the arrow, head to tails. Glad I thought through it, before I called an error...
    Bill

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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