How can I create a graph of the values of two cells where one is the x and the other is the y?

[excelos]

Hello

In an Excel model, I have an input and an output cell. How can I create a graph of the values of the output versus various values of the input cell?

I was thinking if it is possible to simply select the two cells and create the graph automatically, without having to manually change the x value and create a list of the y values.

Thanks!

 

[pgc01]

Hi

You can use the Data Table tool. It's in the What-If Analysis.

You just give a list of x values and the tool evaluates the model for each one and writes the corresponding y value.
You can then use the data to create your chart.