Creating a pie chart for peoples attendance

Hi guys I was wondering if I could ask for a bit of help with a excel document I'm trying to create. I created a document that lets me enter sick days, annual leave days, late starts and early finish days along with overtime hours worked and I would like to create a pie chart that represents those days but for the life of me I can't work out how to do it. 

What I have is 1 overview sheet which shows the total view of the 12 months then I have 12 sheets 1 for each month which lists staff names along with the mentioned days off. The overview sheet takes the totals from the 12 months and lists them in a nice easy to read view. On the right side of the overview sheet I have another page where I have a drop down box to select the staffs name which then fills the boxes containing the mentioned days off coming from the overview page. I also have a number of working days being calculated from July 1 2025 minus listed public holidays and annual leave days we had during the christmas factory shutdown. This is where I would like the pie chart to be in the empty space below here. What I'm aiming for is to have the pie chart dynamically change based on name of the person selected from the drop down box. Ideally I would like the pie chart to represent the number of working days as the whole pie then sick days, annual leave days, late starts and early finishes as a piece of the pie along with the name of each pie section. The overtime hours worked doesn't need to be shown on the graph as thats just reference. 

Any help would be greatly appreciated. I can upload the document as I created a temp file and changed the names so as not to break privacy rules. I don't see a place to attach the file though unless I have gone completely blind. Thanks so much for your help.