I have a pivot table where the people write a task, dates for making it and how 'busy' they get with it on a scale from 1-10.
For example: Martin, "creating examples 1" from Jan 01 to March 15, 6 (slightly busy).
There are other tasks that last longer and I want to be able to make a pie chart of each month that show how busy I am with each task on a percentage of the total tasks, but they don't update on each month. How can I get to do so?

Capture1.PNGCapture2.PNGCapture3.PNG