HomeTroubleshooting@RISK for Excel: SimulationDelimiter Setting Ignored by RiskResultsGraph( )

4.20. Delimiter Setting Ignored by RiskResultsGraph( )

Applies to: @RISK 5.0 and newer

I have a RiskResultsGraph( ) function set up as follows, because I want to set the left delimiter at 20%:

=RiskResultsGraph(F26,H6:Q25,13,FALSE,20)

But after a simulation, the graph still has the left delimiter at 5%.

RiskResultsGraph( ) is applying the defaults that are in your Application Settings, because the function parameters are not complete.

With RiskResultsGraph( ), you must specify both delimiters if you want to change either one. If you want 20% at the left and 5% at the right, use this form of the function:

=RiskResultsGraph(F26,H6:Q25,13,FALSE,20,5)

Last edited: 2015-09-16

This page was: Helpful | Not Helpful