I am trying to create a pivot chart that shows different items. (Purchases, Sales, Inventory Levels). The problem is that these all come from different queries within Access. I know how to bring in one query into a pivot chart. Is there anyway to bring all of them into one pivot chart so that I can show graphically where all of these are in relation to one another? I want to do it in a pivot chart, so that I can drill in by location or look at the overall picture.

Is there any way to bring in these multiple queries (from multiple databases) to one pivot chart?

Thanks
waters130