title: How do you create multiple charts/reports for 1 filtered set of raw data in excel?
body: <p>I am making a set of reports for my job in Excel 2007.<br>
  I have been given a set of raw data, which is organized into one excel table.
  This raw data will change, so the reports I'm trying to make need to allow this.
  I have also been given a set of template charts. 
  These are to be used to reflect results from 22 different groups within my raw data, separately.  For each group the charts are the same, but a new worksheet (with the set of charts) must be created for each group.  </p>
  
  <p>I have spent alot of time trying to do this and I think I'm going about this the wrong way.
  This is a summary of a macro that I made that is close to giving me the end result (which I ended up copying and pasting for all groups).</p>
  
  <ol>
  <li>Filter Raw Data for group only.</li>
  <li>Copy the entire sheet.</li>
  <li>Paste to another worksheet as values only.  (this gives me an error about using too many resources)</li>
  </ol>
  
  <p>So now, for each group, I have a chart worksheet and sheet that has the copied filter results.  Then, I made a third sheet for the chart data.  This sheet has many formulas that run calculations on the filtered data for each chart.  The charts reference these.</p>
  
  <p>Is this really the easiest way to do something like this?  It has been alot of work to copy the macro for each group.  Assign data to each chart for each group.  Plus I have like 67 worksheets in my workbook now.  Is this something pivot tables could do much easier?</p>