I have an excel spreadsheet which has attendance reports for all employees working in the company. I want to create a pie chart which shows percentage of good attendance, late arrivals, leaving early and absences per person and per all employees per week. I have already created a conditional formatting assigning colors to Late Arrival (marked it as LA), Leaving Early (marked it as LE) and Absences (marked it as A). Is it possible to do this? If so, How could I? Eventually will use same data to create a per month and yearly report in form of a pie as well.

I also created totals for Per person for each value and for all employees for each day.

I thank you in advance for your help.

  • Please post some sample data, otherwise it's really difficult to help you. – Máté Juhász Sep 25 '17 at 19:15
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. – Ramhound Sep 25 '17 at 19:47

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.