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