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
Bookmarks