I have quite a complex spreadsheet that boils down to 1 input cell and 1 output cell, and I'd like to graph their relationship as the input is stepped up from say 1 to 100 in steps of 1.

Is this even possible in Excel?

Alternatively is there a way to *distill* the spreadsheet into a single cell? The final output cell pulls together results from other cells, which in turn pull results from other cells, etc. until the *leaf nodes* of this graph if you will are all just constant (of which 1 is my input cell)?