However, no one answered these questions. I don't know the answer either,
other than trying to use Microsoft Graph can be an exercise in frustration.
My suggestion is to learn how to automate Excel from Access to produce your
desired graphs. Here are some KB articles that can help you get started:
Note that you can turn on the macro recorder in Excel to generate most of
the VBA code required to create a chart from scratch. This code usually works
in Access with a few minor tweaks. Another option is to use automation code
to open an Excel template (.XLT) file, which already has the chart
pre-defined. Then, you just need to pump the data into the appropriate range,
and save as a new spreadsheet.
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.