Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 05, 06:50 PM
S.H.C
 
Posts: n/a
Default 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   Report Post  
Old June 24th 05, 07:39 PM
S.H.C
 
Posts: n/a
Default

Each Month is a different Wookbook.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comples Stock Charts MJSlattery Charts and Charting in Excel 1 June 13th 05 03:06 PM
Learning about Charts Nick hfrupn Charts and Charting in Excel 0 June 13th 05 08:21 AM
Stacked Charts w/ Vertical Separation Stacey Charts and Charting in Excel 1 June 10th 05 07:35 PM
How to copy the work sheets from different workbooks into one? Sesh Excel Discussion (Misc queries) 1 April 15th 05 06:03 PM
Stopping Charts Displaying Zero Results SCW Charts and Charting in Excel 4 January 3rd 05 05:23 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017