Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi-sheet bar chart data problems
Hi folks,
I have a multi-sheet workbook. Each page has a sell containing a total - let's call it "D2" again... :o) 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... Data range: ='sheet1:sheet4'!$D$2 ....it returns an error: "Reference is not valid". Any advice? TIA... Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |