Hey guys,
I am a sports coach and I want to have a graph of the xG (Expected Goals) in a game over time. The graph would consist of 4 lines (1 with my teams expected goals, and 1 with my teams actual goals, and the same for the opponent).
I have an application that exports a raw data file in excel and I want to let excel automaticaly form the graph. The image that I will add to this message is the raw data file that I will get after every game. You can tell the time, goals, shots and everything. Every type of shot is a different value for xG. For example, a long distance shot is 0.14 and a penalty is 0.84. I think I can use a stacked line chart for this issue, but I don't know how I can code this.
Can someone help me develop some sort of code for this?
It will need to look a little bit like the other image I will add to this message. But then, I want to add 2 lines (1 for each team's actually scored goals).
Kind regards,
Tjeu
I am a sports coach and I want to have a graph of the xG (Expected Goals) in a game over time. The graph would consist of 4 lines (1 with my teams expected goals, and 1 with my teams actual goals, and the same for the opponent).
I have an application that exports a raw data file in excel and I want to let excel automaticaly form the graph. The image that I will add to this message is the raw data file that I will get after every game. You can tell the time, goals, shots and everything. Every type of shot is a different value for xG. For example, a long distance shot is 0.14 and a penalty is 0.84. I think I can use a stacked line chart for this issue, but I don't know how I can code this.
Can someone help me develop some sort of code for this?
It will need to look a little bit like the other image I will add to this message. But then, I want to add 2 lines (1 for each team's actually scored goals).
Kind regards,
Tjeu
