It is best to have the data in one place.
But that place can reference other worksheets as in
=Sheet3!B4
=[JumpTwo.xls]Sheet1!$L$3

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Novice" wrote in message
...
Can I create a chart using data from two worksheets or workbooks?