Trying to create a chart to show resources that have submitted (as well as not) timesheets

[Naddyboy]

Hello all,

Going mad here and really could use some help.

I have been tasked with creating a sort of 'League of Shame' chart for resources in my company that haven't submitted their timesheets on a weekly basis. I have data that gives the resources name, area they work within the company, a column for time period/week commencing, as well as timesheet status (submitted or unsubmitted). I have attached this information.

I'd like to be able to show by area the resources that have and haven't submitted their time so as to show some kind of trend. I'm not interested in forecasting anything, just some indication of things either getting better (i.e. everyone is submitting timesheets every friday) or worse (number of unsubmitted timesheets becoming greater.) Would also be useful to be able to see who are the repeat 'offenders' as such.

Hope this makes sense! Any help is much appreciated