Graphing data from cells in different worksheets
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Graphing data from cells in different worksheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    I thought this was a relatively simple problem (it still may be), but can't seem to solve it. I want to chart data from various worksheets. I have data for various years, with each worksheet representing a different year. I want to graph information across the years I have, so one cell from 1998, another for 1999 etc. This is for a line graph so I want to select a series of cells each in a different worksheet. I'm using 97 and can't seem to get this to work. I've tried holding ctrl while moving to the next worksheet, tried other seperators - nothing. If anyone can help me out I'd be VERY thankfull.

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sheet 1 name = '1998' cell a1 = 100
    Sheet 2 name = '1999' cell a1 = 200



    Last sheet name = 'To Date' , enter =1998!a1 in say b1 and =1999!a1 in b2

    etc etc etc

    Then the graph grabs info from B1-Bxxxx


    No expert here, but i think that would work fine.


    You can enter an '=' sign in the last sheet , then go click on the cell in the previous sheet, then press return

    Regards

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com