We now have a new view 'Pivot table' available on lists and smartlists. This view enables you to create an adhoc pivot table/chart based on the data from the (smart)list. Additional filtering is available. The graph can also be downloaded as an image.