Before I get started, I haven't invested much time in graphing and charting.

I have been tasked to collect data for each of the next 30 days.

I've created a template which has a summary worksheet and 7 catagorized
worksheets which have data linked back to the summary sheet.

I have planned to collect data in 30 different workbooks (.xls files), and
then afterwards chart the data from each of those files. I would do this by
creating a Summary Workbook, which would have 30 Worksheets which were linked
to the summary sheets of each of the other 30 files. I would then make my
chart from within that Summary Workbook.

This seems like a lot of work.

Should I pan this task differently?

Is there an easy way to chart data from multiple workbooks?

Darrell