Brian, you mean something like this:

[Linked Image from i38.photobucket.com]

http://www.box.net/shared/static/ebziurpk40.dot ?

Currently the backend is a separate MS Access file hidden in the background with only the data imported into a MS Word template. This data can always be linked to the AC tables...

This is another graph, but done within MS Access itself:

[Linked Image from i38.photobucket.com]

Same, looking at diagnoses (as above, filter is applied):

[Linked Image from i38.photobucket.com]

Here I plot my hemeonc portion of my practice to my general medicine patients, and you can see the difference in the patient ages (hemeonc is skewed to the right):

[Linked Image from i38.photobucket.com]

This is a graph of the new to old patients seen daily at my office for the past 2 years:

[Linked Image from i38.photobucket.com]

I apologize for the overdone yellow background; when I did these MS Access graphs back some 12 years ago, I had something for yellow backgrounds. The MS Word graph template is about 8 months old, done a programming show-off with one of Nick's programmers at emrupdate. I hope you can appreciate how I've grown to use color in a better manner!

Anyhow, that's it for graphing fun with the MS Office graphing ActiveX module... a very powerful tool indeed! smile

Al

Last edited by alborg; 03/22/2008 12:22 AM.