offset and large function issue

Hello having some issue with the LARGE function.

basically I have fields that are empty i.e. the branches have not input a employee name.

i have a graph, which sorts the revenue the employee made from largest to smallest.

i have worksheet called "data" where the employee name comes from, so there are 34 employees currently, with 20 extra space. for the extra space, it currently shows a NA()....but when i try to make my calculation for the "large()" function....it messes up and does not like the NA()s.

can someone pls advice!

also, for some reason, when i delete "JOHN DOE" from the data worksheet, my graph is messing up.....can someone pls help wid this issue!!!!!

i have hightlight the cells in yellow.

much appreciated!