Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charts/ Graphs information from more then one worksheet
Well I´m starting to get deeper and deeper into things that I do not
understand :) I have Excel worksheets for every month, each with the name of the corresponding month. What I need to know is if its possible to take information from all the worksheets of every month and put these into a chart or graph so we could track the progress of a sertain person. to be more specific. Example of John Month of May (May.xls) Week1 (numbers) John (#) (#) (#) (#) (all are in the same row as john) Week2 (numbers) Week3 " Week4 " Then we have Month of June(June.xls) and all the weeks Is there a formula or a way to get all the information thats in his row from every week of every month and put them into one chart to see the progress of John? With the worksheets being seperated? Any Help would be welcome! |
#2
|
|||
|
|||
Each Month is a different Wookbook.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comples Stock Charts | Charts and Charting in Excel | |||
Learning about Charts | Charts and Charting in Excel | |||
Stacked Charts w/ Vertical Separation | Charts and Charting in Excel | |||
How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel |