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

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.

Hi
see:
http://www.peltiertech.com/Excel/Cha...iffSheets.html

--
Regards
Frank Kabel
Frankfurt, Germany
"balandino" schrieb im Newsbeitrag
...
I am looking to create a graph, that references cells from two different
worksheets for the same data set.

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.

I indicated you could use a separate sheet (add one in if needed)
You cannot be plotting more that 256 columns so a new sheet would hold the
data.

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


"balandino" wrote in message
...
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.