Percentage of time displayed in a chart

I’m trying to gauge percentage of time spent by employees on different categories to help balance work load.
I have set up a board where a group and employees will populate every week. Each item has five number columns for employees to report estimated hours. Is there a way to display in a chart the breakdown of categories for each week?
It would be nice to have a pie chart to display the categories and then filter by person. I don’t see a way to select all the columns in a pie chart.

Thank You!