Payroll Dashboard

I need to visual graphs & charts that display the attached data set. I need to visualize each employees regular hours, overtime hours, commissions, and total gross by location and collectively too. Also, I'm looking for easy ways to display which employee has the most regular hours, overtime hours, commission, and overall gross pay by location and collectively. I need to be able to paste the new data set each week to visualize a weekly payroll for the calendar year using Google Sheets and not Microsoft Excel. Please assist.