A coworker Ted from GSI used the Access 2000 Chart OCE tool for some nice-looking bar charts in a legacy database; when I looked for the tool in 2007 it was less-than-obvious. However, after playing around with the toolsets for half a day I discovered that it's basically the same graphing engine available in Excel -- just with a terrible interface.
This article summarizes some of the shortcomings (one needs to tweak their own query regardless of how the original is built in the interface), and does a better job than I would've showing you where to start:
To see this in action at GSI check out the GWMA db > hydrograph > frmHydrographByDate > select your well and date range, load it, and click the "Chart" button at the bottom of the page (launches frmHydrographChart).
Learn how to Work Smarter