I'm want to do game analysis for our volleyball team.
vballstats.xlsx
Trying to plot a line graph like the ones you see on tennis matches which players won the last 10-20 points.
Initially, I wanted to use letters A and B for the teams, but seems like Excel can't work with non numerical values, so now I replaced them with 1 and 0 to represent both teams and the chart attached came out as the result, I guess 2nd best option...
Now, I want to increase the number of graphs with pie charts to see which player caused what event (error, winner, etc.)
Tried using Pivot Table or Pivot Chart but no matter how I shift the axis, it's not what I expect.
Is it even possible to do the graph directly from the table attached? Or would I need another table to do the calculations with IFs and COUNTs?
Thank you!
Bookmarks