Graphing data from cells in different worksheets

Armin Tanzarian · Apr 18th, 2002, 02:50 PM

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.

Moradyn · Apr 18th, 2002, 03:13 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 02:50 PM	#1
Armin Tanzarian New Member Join Date: Apr 2002 Posts: 1	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.

Apr 18th, 2002, 03:13 PM	#2
Moradyn New Member Join Date: Apr 2002 Posts: 17	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