[AccessD] How to Change an Access 2007 Chart with VBA Code

I find automating excel from access very challenging. I often dump data
into excel and go write the code to mamopulate it natively in Excel VBE. If
you can leave your code in an excel workbook and call that from Access you
may be better off than trying to run from code ported to Access vbe.

Good luck.