New answers tagged chart
You can also try the Nevron Chart for SharePoint, definitely the most complete charting package for SharePoint. It is not free but you can evaluate it without any limitations (time limited trial). The following online demo shows multi-level drill-down: http://spchartexamples.nevron.com/Interactive%20Dashboards/Interactive%20Drill-Down/default.aspx
Collabion supports Web Part Connections, so you can filter data based on the query string. You'll need to use the Query String filter web part and connect it to Collabion Charts, it's fairly simple. see their docs for more info. Nevron, has something similar too. Hope this helps.
If you're open to 3rd party web parts, both Collabion, and Nevron have an auto-refresh feature with which you can set the chart to refresh after every x seconds. It can pull data from a List, and is probably the easiest to setup.
The corp. Sharepoint environment I work in is pretty much out of the box. I have access to Sharepoint Designer, but can not add any 3rd-party tools. just wanted to add that for anyone else reading this, 3rd party charting tools like Collabion and Nevron make it really easy to do this. they have an auto-refresh feature that updates the chart ...
Another 3rd party chart web part for those who are researching this is Collabion. similar to Nevron, it enables grouping of data
Top 50 recent answers are included