Forum Discussion
Excel_Newb-27
Sep 05, 2020Copper Contributor
Charting Solver solution results
Hi, I am running a solver solution to find the optimal conditions for a fixed set of historic data to help determine reliable conditions for future/live data. I am currently stress testing my so...
Ramiz_Assaf
Sep 06, 2020Iron Contributor
How many decision variables you have?
you can plot only X,Y and Z
so only two variables, you need to use a contour diagram, it would give you something similar.
if you have the file I can give it a look
best of luck
- Excel_Newb-27Sep 17, 2020Copper Contributor
Hi Ramiz,
Thank you for your message, i actually figured out a way to solve the problem shortly after posting the query. I created a table and used a What-If analysis to determine what would happen if the variables were set to the various iterations.
Thank you for your response