
Originally Posted by
TheShabz
I think you're asking Access to do something it's not really designed for. To get the best bang for your buck out of MS Office, you should really learn VBA. You can import data from whatever source into Access, query it, export to Excel, create whatever charts you want, create a Word doc describing it, then attach both to an Outlook email and send it off to whoever you want....ALL from a single form in Access. It really is a powerful tool.
A more direct answer, Access reports have some charting tools but they aren't all that great. I'm not sure you can incorporate both into a single chart, but then again, I don't really use the reporting feature in Access.