Pivot table and countif formula + graph

[exced]

Hi!

I am trying to complete the 3rd tab in this document based on the information from the previous 2 tabs.

Also looking to make a graph where people could pick an employee and the info would appear based on the request type.

I am not very savvy when it comes to Excel but I can't manage to put together the formulas properly for the life of me

Thank you in advance for your help!!

[Bernie Deitrick]

Don't use formulas - pivot your data.