Scatter graph connect 3 different series points

[marc01]

Hi all,

Hoping someone can help me with this scatter plot question.

I am trying to connect 3 data points with a line to help show a pattern of play in a tennis match.

I am able to plot each data point however I would like to connect them together for each play.

The data I have looks like this:

[TABLE="width: 802"]
<tbody>[TR]
[TD]Serve location (x)[/TD]
[TD]Serve location [/TD]
[TD]Return location (x)[/TD]
[TD]Return location [/TD]
[TD]Final shot location (x)[/TD]
[TD]Final shot location [/TD]
[/TR]
[TR]
[TD="align: right"]51[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD="align: right"]61[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="align: right"]54[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]


Once plotted, I have a data point for serve location, return location and final(2nd) shot location.

In the example above I have 10 points detailed, so looking to therefore have 10 lines connecting each of the 3 data points. This will then enable me to see where in a tennis match the serve land, where the return goes, and then where the next shot goes - showing me a simple pattern of play.

Hope that makes sense. Any help would be much appreciated.

Best,

Marc