Help with Merging

[S.H.C]

Is it possible to merge workbooks so that I can take data from them all to
make a chart? If so how is this done? I have a workbook for every month and
need many numbers from each workbook to make some charts to see what progress
we are having.

Any help would be great!

 

[Eddie O]

You should just be able define your data range regardless of whether it's in
the same workbook or not. You can have multiple sets of data be drawn into
one chart, from several workbooks. First, open up the workbooks you want to
draw data from (in addition to the one where you will have the graph). Start
the Graph wizard in your "Master" workbook. When you get to the second step
of the Graph Wizard, click on the colored icon at the right of the Data Range
field and select your data ranges from the other workbooks. The rest should
be fairly simple.

Eddie O