Graph and Cell References

B

balandino

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

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
 
B

balandino

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
 
B

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.
 
Top