Forum OpenACS Q&A: Response to Database-backed animation
If you want to do graphs (pie, bar, line, etc.) then you could easily add support for TGDChart, a gdchart module for Tcl to Michael's app.
I've been using TGDChart successfully in AOLserver to generate graphs from information in Oracle. The pie charts seem to have a problem when you use less than 3 data sets. I found the function call where it crashes, but haven't had time to try to fix it.