Average number of employees per hour

I can't come up with a good way to calculate or display this data.

I need to be able to report the average number of employees by Job Code (Column J) over a 6 month time frame.

I figured I would use 5 different charts for Monday thru Friday.

I think I want a multiple line graph with each line representing a job code. X axis to be hour of the day, y axis to average # of employees.

Thanks!!!