I am setting up a stock chart where the data is to be in the order: high,
low,close.

Is it possible to use this type of chart if the "high" data is listed daily
in worksheet 1-cells b3,c3,d3, e3 etc, and the low data is listed daily in
worksheet 2- cells b3,c3,d3,e3 etc and the close data is listed daily in
worksheet3 - cells b3,c3,d3,e3 etc.? I cannot seem to change worksheets to
get the required data? Is there a trick to this or is it absolutely necessary
to have the data arranged on one worksheet? Thanks for your assistance.