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