OK, let me re-word my issue: How do you get your summary data into a format all these add-on charts use? Because they don't seem to like summary data--they want raw data.
If I understand you're problem correctly, essentially what you're going to need to do is build your own summary data using a script.
1. Get you found set
2. Sort it by date
3. Loop through your data and build a series of variables
Month ( Date ) = 1 ; $JanuaryTotal + Total
Month ( Date ) = 2 ; $FebruaryTotal + Total
Month ( Date ) = 12 ; $DecemberTotal = Total
4. Send your data to Google
Obviously this is much simplified; you'll need to consider that your found set might span more than a year, might not begin in January, might spread over a December 31 / January 1 period, etc. If I'm on the right track, though, let me know and I can help you out more.