How to Generate a Graph in Excel

[nedyarb]

Hello,
I have a excel document which generates an answer in one cell depending on the value in another cell. I would like to make a graph showing how the answer changes as the value in the cell changes, however I have no idea how to do this as my spreadsheet only shows one answer at a time. How do I fix this?

Thanks,

[AliGW]

You would need to set up a table showing values in one column and answers in the other and base the graph on that. Excel can only graph what is there on the sheet.

[nedyarb]

Is there a way to generate a table such as that without having to manually copy and paste the answer every time I change the value in the other cell?

[AliGW]

There may be using VBA - shall I move your thread to that section?

[MrShorty]

Can you explain in more detail exactly what is going on here? I don't understand why you are limited to only two cells for this calculation and chart.

One of the most basic "mechanics" of using a spreadsheet is the idea of copying and pasting and entering inputs into multiple cells. The way I envision doing something like this is
1) Enter the inputs into a column (not a single cell).
2) Enter the formula in the first cell (pay attention to relative and absolute references https://support.office.com/en-us/art...e-b50a667eb491 to make copying easier), then copy paste the formula into the column adjacent to the inputs entered in step 1.
3) Build chart from table.

But that obviously uses more than two cells. What is going on in your spreadsheet that it is limited to two cells?