Graph and Cell References

[Guest]

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

 

[Bernard Liengme]

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

 

[Frank Kabel]

Hi
see:
http://www.peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

 

[Guest]

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]

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.