Clustered column chart showing incorrect second column

Hi guys,

Seems a simple thing but I can't seem to figure it out.

Basically, I have two sets of data -

1st set contains all people who have been tested and their score.

The 2nd set has the scores for just those who have been accepted in to the school.

I have created the same groupings for both exam scores e.g. Below 100, 100-104, 105-109 etc.

I want to display both sets of data in a clustered column chart so I can see difference between % of all tested vs % accepted, for each score group.

The 2nd set of data displays fine and has the correct figures, but the 1st set has incorrect figures and a large Blank (I assume these are the people who haven't been accepted)

Help appreciated. Thanks