microsoft excel – Spreadsheet (Specifically Google Sheets) to generate a line chart with each player’s running score (competition tracker)

I asked this question on, but didn’t get an actionable (at my level of expertise) answer.

I’m trying to create a competition score tracker/graph that displays this information:

Each time an answer is submitted, the response sheet will display the time of the submission, the player’s name, and 8 “flag” cells, one for each flag in the challenge. The only flags that will have data will be correct flag submissions (thanks to Google Form’s “response validation”), and my expectation is that each player will be submitting once for each flag, although players can and should be allowed to submit multiple flags at once. Once factor that I have to account for is that players might re-submit previously submitted flags, so I want to account for that before the score is tallied and displayed on the graph.

Along the X-axis, the graph would track the time that each answer is submitted.

Along the Y-axis, the graph will display the total score.

Each colored line in the line graph will be a different player (my expectation is approx. 5-10 players total). As I linked in the reddit post, my hope is to display a graph that functionally resembles this one, and I’ll use Google Sheets to “publish” the graph so that it can be viewed throughout the competition.

Thanks for any help you can provide. I’m really hoping to get this built by Tuesday, as my office is trying to run a mini-competition as a skills-refresher in cybersecurity principles based on a recent course a number of our new co-workers just completed.