Creating a table using a spreadsheet as a function

[whk051]

Example.xlsx

Hey Everyone,
I am not sure I worded my title correctly, but here is my question. It's probably pretty easy but I haven't figured it out and since I am not sure how to word what I want to do, googling it hasn't helped.

I have a spreadsheet where cell A1 is a numeric input (user can enter between 1 and 10000). Based on that input, the spreadsheet does some extensive calculations then in cell B1 the result is displayed.

I would like to chart how B1 changes relative to what a user puts into A1. Now, I can create a data table using a macro that manually copies and pastes values from the first column of the table to A1 and copy and paste the result into a second column from B1, then chart off that table but that is clunky and not very elegant. Is there a simpler solution?

Thanks for helping a forum newbie

- Ralph