| 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 | |||
Linear Mode
