Forum Discussion
Creating a pie chart for peoples attendance
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.
I think you will need a Pivot Table, Create a new Sheet, Add a pivot Table, then add Slicers to select the person. When you highlight a person (or group of people) the chart will update. Then create a chart based on that table. You can copy/paste the Chart and slicer to your main sheet, and leave the table there to do the work in the background.