Tornado graph
Closed this issue · 6 comments
The tornado graph does not print out. It stays blank although the right output cell is referred to (sum of variables).
Which Excel version do you use. I have seen this was not working in some older Excel versions.
Thank you for your feedback. I use Microsoft Excel 2019 MSO (16.0.10361.20002) 32-bit
I am not sure what is the problem. The tornado diagram is produced from the correlation results. It works in some Excel versions and doesn't on others. If you are familiar with VBA and you can debug the problem I would be most grateful.
Thank you. I will let you know if I find a solution. I also have the issue that, following your correlation table example and linking this table to the formulas in the variables, I get the following error message: "The risk input functions have not been properly linked to the correlation matrix at Sheet1!$K$13:$M$15
the formula in the cells is: =RiskPert(K6;L6;M6;RiskCorrmat(K13:M15;1))
When I press 'Show samples', it works. I only get the error message, when I press 'Run'.
Have you changed the name of the worksheet containing the Tornado chart, by chance? I'm facing a similar issue, and am landing on the use of the Indirect formula when defining the TornadoX and TornadoY named ranges.
Please try the latest version of the addin and report back regarding this issue.
I believe this issue is now fixed.
Please report back (here or open a new issue) if this issue persists.