Chart plugin module for MS Access
I'm having trouble with inline access charts, see this question . I am now looking for alternatives to MSCharts that connect to Access. My initial google search only showed noise.
It doesn't have to be open source and it can be worth real money.
a source to share
I don't have specific answers to give you an answer to this question, other than suggesting exporting the relevant data to Excel and creating charts in Excel.
See the following urls for some sample code to export data to Excel
Modules: Excel Automation Example
Modules: Transferring Records to Excel Using Automation
Problem: I have no code to create charts in Excel. I suggest starting at http://www.mvps.org/links.html#Excel or looking in MVP Excel charts. (MVPs is short for Microsoft Most Valued Professional. A search with the MVP keyword will likely give you some FAQ and sample code pages.)
a source to share