Creating a Dynamic Chart Based on Variables

I don't understand exactly what you are trying to do. Based on what I understand, here's how I would probably begin setting this up:

1) In A1 enter "W", B1 -- "D", C1 -- "SF", D1 -- "A"
2) In A2, enter the starting value for W (2), in B2, enter the starting value for D (1). In C2, enter the desired formula for SF, and the desired formula for A into D2. Pay attention to absolute and relative references so you can just copy these cells down.
3) In A3, enter =A2+0.25. B3 -- =B2.
4) Copy A3:B3 and paste down until W is 4 (A10:B10?)
5) In A11 (or whatever is right beneath the max value of W), enter a new formula =A2. In B11, enter =B2+0.25.
6) Copy A11:B11 and paste down until you have the complete matrix of W and D values.
7) Copy C2:D2 and fill in the SF and A columns.
8) The sort operation may work just fine at this point, but I would probably copy columns A and B and paste as values to avoid any problems caused by the sort.
9) Select the table of values and sort by the SF column, then by the A column.

That's how I would do this. Am I understanding correctly? Where do you get stuck?

A few options:

1) Easiest is probably to use a 2D data table. The output won't be in the nice list format that you describe in the OP, however. The output of a 2D data table will have the W values down the left side of the output, D across the top of the output, and the SF values in the body of the table. But it should be a very quick and easy way to compute SF at multiple different W and D input values. This kind of format will not lend itself well to sorting. Some simple lookup functions could be used to convert the 2D data table output to the list output you wanted.
https://support.office.com/en-us/art...2-77542a5ea50b
https://www.excel-easy.com/examples/data-tables.html

2) Rearrange your SF sequence of calculations so that it fits into a single row. This row then gets appended to the right of the desired output table and the final SF result ends up in column C as currently demonstrated. These helper columns can be hidden, if you tire of looking at them.

Please Login or Register  to view this content.

3) If this SF calculation is one that you will use frequently in many different spreadsheets, I would be tempted to write a VBA user-defined function (UDF) to perform the sequence of SF calculations. My introduction to UDFs: https://www.excelforum.com/tips-and-...uild-udfs.html