Hi all.
I am looking to use a line graph to show momentum changes in a tennis match.
I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when player B win's. Then another column to show when player B wins the point and NA () when player A wins.
I have seen an example of this before where if player A wins the line in blue, if player B wins the line is yellow. Also the markers are either green if a winner is hit or red if an error is hit. I wanted to know if this is possible with Excel or if I would have to use power bi or the like?
Any help would be much appreciated.
Thanks.
Marc
I am looking to use a line graph to show momentum changes in a tennis match.
I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when player B win's. Then another column to show when player B wins the point and NA () when player A wins.
I have seen an example of this before where if player A wins the line in blue, if player B wins the line is yellow. Also the markers are either green if a winner is hit or red if an error is hit. I wanted to know if this is possible with Excel or if I would have to use power bi or the like?
Any help would be much appreciated.
Thanks.
Marc