How do you make a graph in Excel by varying the value of a certain cell over a certain domain?
Posted on 2011-10-10
In my Excel spreadsheet, I have one cell where you input an arbitrary value, multiple large tables of calculations, and then one cell that contains the final result, which ultimately depends on what is in the input cell.
I would like to make a graph that shows how the Result cell varies depending on the Input cell.
For example, I would like Excel to plot "Result vs. Input" over a domain of Input from 0 to 1000 in increments of 1.
I know I could do this manually by manually calculating a table with the values of Input and the values of Result for every integer between 0 and 1000, but that seems like a tedious process that Excel should be able to automate.
How could I achieve my objective?