spreadsheet graph

[CoD]

A mate wants me to make him some graphs from spreadsheets

the thing is, he needs the values from serveral differant spreadsheet file onto the graph is this possible

FULL EXPLIANTATION
basically they have the amount of work spilt into weeks. each week gets its own file.

A property on every spreadsheet is average tasks completed (calculated from all the days sun-sat)

He wants a graph of the tasks on the y axis and the week number on the x axis

Is this possible becuase i thought for a graph it had to be on one spreadsheet file.

Thanks

[Woof]

I'm sure you can.
Data > Import External Data > Import Data.

You should have a 'Select Data Source' box appear when you can choose various sources, such as access and Excel formats.