Forum Discussion

Copper Contributor

Mar 16, 2026

Solved

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...

Charting

Olufemi7
Mar 19, 2026
HelloHDFanboy,
Create a small table on the overview sheet that links to the dropdown values. Category Value: Working Days =TotalWorkingDays-(SickDays+AnnualLeave+LateStarts+EarlyFinishes), Sick Days =SickDaysCell, Annual Leave =AnnualLeaveCell, Late Starts =LateStartsCell, Early Finishes =EarlyFinishesCell. Select this table and insert a pie chart. The chart will update automatically when you select a different staff name. Add data labels showing category name and percentage. Make sure Working Days is calculated as Total minus the other categories so the pie shows the correct proportions.

Olufemi7

Iron Contributor

Mar 19, 2026

HelloHDFanboy,

Create a small table on the overview sheet that links to the dropdown values. Category Value: Working Days =TotalWorkingDays-(SickDays+AnnualLeave+LateStarts+EarlyFinishes), Sick Days =SickDaysCell, Annual Leave =AnnualLeaveCell, Late Starts =LateStartsCell, Early Finishes =EarlyFinishesCell. Select this table and insert a pie chart. The chart will update automatically when you select a different staff name. Add data labels showing category name and percentage. Make sure Working Days is calculated as Total minus the other categories so the pie shows the correct proportions.