Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

Charts/ Graphs information from more then one worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
S.H.C - 24 Jun 2005 18:50 GMT
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!
S.H.C - 24 Jun 2005 19:39 GMT
Each Month is a different Wookbook.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.