Hi All,

I am trying to use data that is automatically generated by our video analysis software to plot passing patterns on a graph in excel. What I am trying to achieve is here: https://files.me.com/smithac23/a5su9f.

Our analysis software spits out co-ordinates. These co-ordinates refer to a 5x5 square on the hockey field. The hockey field is 100x60. I am trying to get excel to plot the following

18 4 2 7

Square 18 4 is where the pass originates from and square 2 7 is where the pass ends up. I have played around with xy scatter graphs and cant get it to do what I need!

If anyone could help we would be eternally grateful!

Thanks

Andy