A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pulling data from separate tabs



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2004, 07:05 PM
Dave Cascio
external usenet poster
 
Posts: n/a
Default Pulling data from separate tabs

When charting in Excel 2002 is there a way to use sets of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data from
both?
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current Year'!'$B$110:$M$110

but receive an error that I'm referring to an external
worksheet.

I've used the comma (') in the past to reference breaks
in data within the same tab and worksheet. Is it just
that it won't work across separate tabs?

  #2  
Old April 21st, 2004, 10:22 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Pulling data from separate tabs

Dave -

I'm not sure what the error means. You can use a comma to indicate
different areas of a discontiguous range, but all areas must be on the
same sheet. You could use Copy - Paste Link to get all the data onto the
same sheet, then chart from the summary sheet.

Here's more information about charting from different sheets:

http://peltiertech.com/Excel/ChartsH...entSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dave Cascio wrote:

When charting in Excel 2002 is there a way to use sets of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data from
both?
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current Year'!'$B$110:$M$110

but receive an error that I'm referring to an external
worksheet.

I've used the comma (') in the past to reference breaks
in data within the same tab and worksheet. Is it just
that it won't work across separate tabs?


  #3  
Old April 22nd, 2004, 03:42 PM
Dave Cascio
external usenet poster
 
Posts: n/a
Default Pulling data from separate tabs

Thanks for the feedback, Jon. I had already figured
there was no way around it and I created a summary sheet
with all the data.

Dave



-----Original Message-----
Dave -

I'm not sure what the error means. You can use a comma

to indicate
different areas of a discontiguous range, but all areas

must be on the
same sheet. You could use Copy - Paste Link to get all

the data onto the
same sheet, then chart from the summary sheet.

Here's more information about charting from different

sheets:

http://peltiertech.com/Excel/ChartsH...artDataFromDif

ferentSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dave Cascio wrote:

When charting in Excel 2002 is there a way to use sets

of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data

from
both?
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current

Year'!'$B$110:$M$110

but receive an error that I'm referring to an external
worksheet.

I've used the comma (') in the past to reference

breaks
in data within the same tab and worksheet. Is it just
that it won't work across separate tabs?


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.