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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|