MS Excel Charts from MS Access

[tranchemontaigne]

HISTORY: I've been working on creating MS Excel charts from MS Access as the closing piece of more than 3K lines of code used to generate a single complex report. Unfortunately, I have not been able to figure out how to define the data range in my code. I can dynamically define data series and create the chart, but at the end of the method I find myself having to go into Excel, and manually defining the data range. Once this manual step is done the chart automatically adjusts to be exactly what I am looking for. Unfortunately the approach I have been working with to make the chart is not very elegant.

CHARTWIZARD EXCEL VBA METHOD: Recently I learned about the Excel VBA ChartWizard method and am considering re-writing code to support this approach, but have not found a working example of this code.

RANT: Despite contacting the author and publisher of Alison Balter's "Mastering Microsoft Access 2000 Development," (ISBN 0-672-31484-3) the only response I have received is "talk to someone else..." if you want any of the code, examples, and sample office automation databases from chapter 26 of our book (or the companion CD) to become functional.

OBJECTIVE: Graph multiple data series in an Excel chart.

REQUEST: Does anyone have a good sample code for creating an Excel chart from MS Access (with multiple data series) using calls to the MS Excel VBA chartwizard method?

COMMENT: I've looked at CraigDolphin's code and found it very specific to his application and am looking for a more rudimentary example.
________
Bmw r75/5

 

[KenHigg]

You may want to consider manipulating the graph/chart object directly. Here is the official help file:

Link

 

[tranchemontaigne]

Ken, thanks for the post. I'm using Office 9, not 10. I found a copy of vbagrp9.chm. I'm looking through it now.
________
Easy vape