title: Add Chart Data from other Workbooks into one series with VBA - Excel 2007
body: <p>I need to create a Chart which will grab data from external sources when a macro is run. Setting up the UserForm and all that is fine, all done.  However, I can't find out how to add another piece of the series.</p>
  
  <p>Is it even possible to have a series that sources data from several different locations? Basically I need it to go in chronological order (Horizontal Axis are all dates), but each date comes from a different workbook entirely.  I have tried to get Excel to do this with its basic functions. I just can't get it to put it into the graph. If possible, I would like to not have to copy all the reference data to the workbook with the graphs, as it is already going to have 16+ Charts that will be on their own sheet.</p>
  
  <p>Does anyone know how to make Excel accept many different references into one series? How it would be done with VBA? I'm not too bad with VBA, just haven't had to deal with Charting before.</p>