For project reporting purposes I would like to track the effort spent for the different categories in my team area.

Ideally I would like to create a chart (pie chart, bar chart, etc.) base on a query, which displays the effort spent for each category.

The "Work Item Statistics" widget allows me to do something similar, but instead of summing the effort spent it just counts the work items of each category.