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
Subscribe to: Post Comments (Atom)
3NF (1) About Me (3) Access (10) Beginner (1) Excel (7) key (2) MSDN (1) research (2) Software development theory (1) structure (1) sverige Visualization (1) VBA (1) waterLevels hydrograph hydrology (1) XML (1)
Post a Comment