Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi-sheet data charting problem
Hi folks,
I'm relatively new to the "joys" of Excel, so go easy! I have a multi-sheet workbook. Each page has a cell containing a total - let's call it "D2". I want to take data from cell "D2" on each sheet and make a "clustered column" chart. I also want each column to take the name of each sheet, thus: __ __ __ __ __ __ __ __ __ |______|______|______| sheet1 sheet2 sheet3 etc. Is this possible? I have tried using the Chart Wizard but, when I select cell D2 across all sheets, thus: Data range: ='sheet1:sheet4'!$D$2 ....it returns an error: "Reference is not valid". Presumably this is because I'm trying to create a chart using only one cell from each sheet... any advice? Is there potentially a better way to manage my data than the way I'm doing it now (without re-doing the whole thing)? ARGH! TIA Jim |
#2
|
|||
|
|||
Jon Peltier has instructions for charting data from different sheets:
http://www.peltiertech.com/Excel/Cha...entSheets.html Jim M wrote: Hi folks, I'm relatively new to the "joys" of Excel, so go easy! I have a multi-sheet workbook. Each page has a cell containing a total - let's call it "D2". I want to take data from cell "D2" on each sheet and make a "clustered column" chart. I also want each column to take the name of each sheet, thus: __ __ __ __ __ __ __ __ __ |______|______|______| sheet1 sheet2 sheet3 etc. Is this possible? I have tried using the Chart Wizard but, when I select cell D2 across all sheets, thus: Data range: ='sheet1:sheet4'!$D$2 ...it returns an error: "Reference is not valid". Presumably this is because I'm trying to create a chart using only one cell from each sheet... any advice? Is there potentially a better way to manage my data than the way I'm doing it now (without re-doing the whole thing)? ARGH! TIA Jim -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
In article , Debra Dalgleish
wrote: Jon Peltier has instructions for charting data from different sheets: http://www.peltiertech.com/Excel/Cha...entSheets.html Sorry, but I've already looked at that page and none of it means much to me. As I've mentioned, I know hardly anything about Excel. /And yet I'm forced to use it against my will!!/ Just kidding... ;o) Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with external data | Excel Discussion (Misc queries) | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
getting data from 2 different exc sheet | Excel Worksheet Functions |