Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with charting data from multiple worksheets.
I am trying to update a chart that originally had all of its data on one
worksheet but now has it on two worksheets. When I try to change the formula to include both Sheet 1 and Sheet 2, it gives me an error message staing that my formula is either incomplete or that it is incorrect. This is what my formula looks like: (in the Source Data Window) =('Sheet 1'!$B$34:$B$45,'Sheet 1'!$B$49:$B$60,'Sheet 1'!$B$64:$B$75,'Sheet 2'!$B$93:$B$103) Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charting data across a range of worksheets | Charts and Charting in Excel | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Is there a way to totalize data from multiple worksheets? | Excel Discussion (Misc queries) | |||
Merge Data From Multiple Worksheets | Excel Worksheet Functions | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |