Is it possible to chart a point value with a thrid vector value (ie a rotating arrow?)

Do you prefer VBA as a programming language? I don't think VBA would be "required" for this task, it would just be one possible programming language to choose. I generally prefer the basic spreadsheet formula language and not resort to an external (to Excel) programming language, but that is my personal preference.

What chart type are you using? I find that adding vectors is much easier on a scatter chart. I cannot tell from your picture what you have, but it shouldn't be a problem as long as you are comfortable converting to a scatter chart. If not, then we may need to do some more work in the sheet to prepare the extra data series.

Obviously, Excel does not have a built in "draw a vector on a chart" utility, but, as long as we are already comfortable with the math/trig of working with vectors, it is relatively easy to program in for one point/vector. The basic idea is to choose/calculate two points in the spreadsheet to represent the vector, then add those two points as a new series, formatted as line without marker and format the line to look like an arrow:

1) Choose a starting point. In your picture, it seems pretty arbitrary (somewhere near the middle of the chart). Enter the x and y coordinates for this point.
2) Somewhere, you have a bearing for the wind speed. I don't know if you intend to make the length of the vector arrow be related to wind speed or an arbitrary length, but you need a length for the vector. Once you have both length and bearing (polar coordinates, if you remember your trig) for the vector, convert those to rectangular coordinates and add to the starting point from step 1. Some thoughts in this post that may help when working with compass bearings rather than standard angles: https://www.excelforum.com/tips-and-...ml#post4309792
3) Make sure the results of 1 and 2 are reasonably arranged in the sheet so they are easily added as a new data series to the chart (again, this is where using a scatter chart makes this really easy), then add the new data series to the chart (I usually recommend using the Select Data dialog for this -- especially if you are new to Excel and unfamiliar with other ways of adding data to a chart).
4) Format the new data series to have the desired arrow appearance.
5) Evaluate and adjust as necessary.

Will that work for you, or is there something I have misunderstood?