title: Create PowerPoint charts from MS Access queries
body: <p>I have an Access db to track metrics and "number crunch" data to build PowerPoint presentations. I do about 40 presentations per month, and they are 98% charts.</p>
  
  <p>I run queries one at a time (using SQL statements), take the resulting data and copy it into an Excel template (I made a mock table in this "template" so the chart is already built and formatted), then copy the chart as a picture into a PowerPoint template.</p>
  
  <p>So there is a lot of manual work.</p>
  
  <p>How can I run multiple queries in Access with VBA on the same dataset/table (I have to do sales by quarter, by month, by region, by state, by site and all of these are Top5 aggregate, hence the reasons for the charts), and then send the resulting data to a specific Excel workbook, while defining what goes into what cell range?</p>
  
  <p>If I get all the data into Excel, and have the charts ready to go, is there some VBA that will take the charts from Excel (activeworksheet) and paste them into PowerPoint as pictures in a quad view layout?</p>
  
  <p>Can I do the same thing with an Access to PowerPoint approach and cut out Excel?</p>
  
  <p>I am a novice at best.</p>