EDIT: IF you need help programming pivot charts, or pivot tables and automating the creation of them, PM me AND email me, as I have completely resolved this issue and there is not much help available on any forums for Access 2007.
So I know VBA with pivotcharts is kinda sketch. But what I'm...