I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet.

How I would relate these two sheets so that when I make any changes in the figure in the first sheet then it should automatically reflect on second graph sheet