Armin Tanzarian
New Member
- Joined
- Apr 17, 2002
- Messages
- 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.
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.