Caroline
In the past we've had good results with FusionCharts http://www.infosoftglobal.com/FusionCharts/ . Its not open source (although there is a free Lite version) but its relatively cheap and works well. It uses an XML data feed and displays the results using Flash in the client browser in a variety of configurable formats.
- Steve