Scatter plot diagram

[#1]

Hi all

I am looking to create a scatter plot diagram to display relationships in my data set

I would like to display the number of DefensiveRuckNumbers for each Opposition Play in each PhaseNo

A sample dataset appears below

PhaseNo, DefensiveRuckNumbers, PhaseOppositionPlay

1,0,9+1 Outside

2,0,9+2

3,1,Wide Play

1,1,10+1 Outside

2,4,9+1 Outside

3,2,Wide Play

4,0,9+1 Outside

5,0,9+1 Outside

1,1,10+1 Outside

2,0,9+2

1,3,9+1 Outside

2,1,Wide Play

3,0,9+1 Outside

Thanks

[swuehl · Accepted solution]

Maybe using a grid chart with dimensions Opposition Play and Phase No and expression =Count(DefensiveRuckNumbers)

?