Forum Discussion

HDFanboy's avatar
HDFanboy
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's avatar
    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.

m_tarler's avatar
m_tarler
Silver Contributor
Mar 16, 2026

I think the missing piece is the # of 'regular' days.  So in the image below I show Employee X with a list of days below it for sick, leave, etc.. (the ones you mentioned), but then I added a row called 'Regular' which is simply the Total days - SUM( sick, leave, etc... ).  Then I can highlight that range (G2:H8) and say insert pie chart.