Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Merging
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! |
#2
|
|||
|
|||
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 "S.H.C" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging cells and maintaining the fonts size of each cell | Excel Discussion (Misc queries) | |||
Merging Two Cells and Keeping the Values | Excel Discussion (Misc queries) | |||
merging two excel spreadsheets - track changes from original | Excel Worksheet Functions | |||
Merging data from Excel to Word | Excel Worksheet Functions | |||
WRAP a text line over several columns without merging cells | Excel Worksheet Functions |