need help with charting data from multiple worksheets.

A

at

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement with multiple VLOOKUPs 0
CountIf from multiple sheets in another workbook 4
Can the IF function be used with values from multiple worksheets? 4
Need help 3
need a macro to append data to a table 3
Vlookup Multiple Criteria - Please help 1
Dynamically Change Chart Data Range 1
How to insert new worksheet based on # of rows in a data sourch 2

Top