I have setup a Matrix using TimeSpent to look at time spent per department, but I'd like to turn this into a scheduled report with a pie chart, however the chart only appears to count the number of requests rather than the time spent on those requests.

Is there a way of achieving this without running the data through Excel? Assuming it can be done in Excel, I haven't tried.