Yes, but it is minimal. You can experiment by using the Chart Wizard when
you go to create a New Report. However, for any heavy-duty graphing, your
best bet is to use Office Automation to create graphs in Excel. You'll have
much more functionality. There IS a learning curve, though.
I'm in the same boat. My users have Office 2003, with Access and Excel.
What's the best way to get started in learning how to integrate Excel's
charting and graphing features with Access?
Good question. There's precious little information about Office Automation
out there. The few times I've done it, I've had to scrounge for
information.
Helen Feddema has a few good articles on her site about the Word and Excel
object models. She also has some samples integrating Access and Word
(though sadly, none with Excel or charting). Her site is here: http://www.helenfeddema.com/.
Google is probably your best friend here. Try searching on: Office
Automation Access Excel. Several links I found were:
Open Excel. Turn on the macro recorder. Create your chart. Turn off the
macro recorder. Go to macro-edit and you will find the code Excel generated
to create your graph. You can copy and paste it into Access as a starting
point. You will have to modify the code some for it to work in Access.
Before you can run the code in Access though, you will need to open an Excel
instance in Access. Automation does this for you.
Microsoft exposes excel charting and graphing via the Microsoft Office Web
Components. It's a free download that's easy to use and basically makes the
excel engine available to applications that require that type of
sophistication.
Version 11 of the MS OWC is available here http://www.microsoft.com/downloads/details.aspx?familyid=7287252C-402E-4F72-
97A5-E0FD290D4B76&displaylang=en
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
