I need to keep track on a daily basis how many hours are being used by multiple people from the total number of hours allocated to a job.
I would also like, if possible, to show this data in a pie chart for easy reference.


For example, I have 15 people, and, say 30 jobs, each job having an allocated number of hours. Some of the people may work on more than one job during a day. I have previously done a spreadsheet showing the Person/Area/Hours spent but I am lost how to convert this to a pie chart.
Any advice on the spreadsheet and pie chart would be greatly appreciated.