Thank you very much for your reply. That does work if you have enough room
in your data sheet, but I do not. I have already used all of the columns
avaliable, hence the necessity to go to a second worksheet. Sorry I did not
explain that in the original problem. Any suggestions with this
clarification.

Thanks


"Bernard Liengme" wrote:

I would use part of one of the sheets (or a third possibly hidden sheet) to
consolidate the data with formulas such as =Sheet1!A5 and =Sheet2!G2
Now make the charts anywhere you wish from the consolidated data.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"balandino" wrote in message
...
I am looking to create a graph, that references cells from two different
worksheets for the same data set.