In Access, you could use the TransferSpreadsheet method to send the data
to Excel. Then, in your Excel workbook, you could use Workbook_Open code
to create the chart as the file is opened.

vince wrote:
Hi,
i currently export from Access to Excel in order to leverage Excel's
advanced charting features.

Is there a way to generate those Excel charts directly from Access?

thx

vince


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html