Realized I din't completely answer your question. Based on Relationship Test and considering the source data (Excel) file only has data from P1 (Preseason week 1) and P2, I believe I should (Or I want) only have a singular GREEN dot for BUF; a BLUE dot for CAR in P1. For P2 I want to have a singular GREEN dot for BUF; a BLUE dot for CLE ; and a Yellow dot for NYG.
Play this out to P4 I would have
1 GREEN dot for BUF
1 BLUE dot for CHI
4 YELLOW Dots for BAL,CIN,DEN,KC
NOTE: CHI has an extra Preseason game and thus the 4 yellows vs 3 for almost any other team. BAL is the only other team which has the extra Preseason game. i.e. P1-P5 vs P1-P4.
I hope this helps.