stacked side by side charts

[Guest]

I have posted a question on this twice, but can't find either question, let
alone any answers. What am I doing wrong?

Thanks

 

[Guest]

Hi Steph,

Your three previously posted questions on this subject can be found here:

http://www.microsoft.com/office/com...31de&dg=microsoft.public.access&lang=en&cr=US

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:

Using Automation to Create a Microsoft Excel Chart
http://support.microsoft.com/?id=202169

Using Automation to Transfer Data to Microsoft Excel
http://support.microsoft.com/?id=210288

OFFAUTMN.exe discusses Office 97 and 2000
Automation and provides sample code
http://support.microsoft.com/?id=253235

The Office XP Automation Help file is available for download
http://support.microsoft.com/?id=302460

Sample Excel Automation
http://www.mvps.org/access/modules/mdl0006.htm


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.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________