Get well soon r3wt.
I have some chart code I have been working on, using google charts. Would you be interested?
I've got candlestick prices, and stacked columns for volume (showing buy and sell volume separately).
I believe for stability it is best to setup charts to use its own database so it does not tax the main exchange database, and I have setup for this.
The charts database keeps record of all transactions that occur for each market, and then it is parsed into the appropriate JSON responses via PHP, then fed into Google Charts via AJAX.
Edit: And separately, I have a PHP script that periodically grabs all the most recent transactions from the main exchange database and puts them into the charts database. Right now I don't have a way to automate this script, but maybe a cron job would work.