charts

[Guest]

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.

 

[Sean]

Hi,

Try this:
Right click on your chart and select "Source data"
On the series tab you should have 3 series (I have on the dummy one I
created to test this)
Select and one of the series and click in the values box and select the
appropriate worksheet range. This range can be on any sheet and in either
rows or columns

Hope this helps.

Sean