Does anyone know how to recreate this line graph?

[marc01]

Hi all,

I am wanting to recreate this type of line graph and wondering if anyone knows whether it is possible with excel without VBA? Or does it need VBA or done on power bi?

The data I have in columns is:

[TABLE="width: 694"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Server[/TD]
[TD][/TD]
[TD]Set Score [/TD]
[TD]Marie serving[/TD]
[TD]Maia serving[/TD]
[TD] Momentum Total [/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]-1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]-1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]-1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]-1[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Marie Benoit[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: right"]-2[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD]Maia Lumsden[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-3[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD]Maia Lumsden[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-2[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD]Maia Lumsden[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD]Maia Lumsden[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Maia Lumsden[/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]


Trying to recreate this type of graph, but so far no success.....

Any help would be much appreciated.

Thanks,

Marc

 

[oldbrewer]

look at jon peltier's website

and - what does it mean - what sort of chart - maybe google sheets - just draw the chart freehand ?

 

[marc01]

Thank you, I will take a look at this.