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