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)?