Applies to: @RISK 6.2 and Up, Professional and Industrial Editions

Issue:

Define Custom Color button grayed out

Cause:

The button is grayed out by design.

Solution:

To use custom colors, create the graph in VBA using the CurveColor method of the RiskGraph object.

See Help » Developer Kit (XDK) » Automation Guide for examples, or review the attached example spreadsheet. Use CurveColor before ImageToWorksheet and RGB values (0–255) to set curve colors.

For setting colors specifically, you need the CurveColor method of the RiskGraph object.

• It's in the @RISK XDK Reference in the Help » Developer Kit (XDK) menu but you can also view the attached file, which is a modified form of our example spreadsheet found at Help » Developer Kit (XDK) » Examples » RISK XDK – Creating Graphs 2.xlsx.
  • In this example, on the Model worksheet, click Run Simulation and then Distribution Graphs of Outputs. All of the graphs are placed on the Graphs1 worksheet, in a 5×4 array.
  • Press Alt+F11 to view the code, and look at the Graphs1 subroutine.
  • Before calling the ImageToWorksheet method, use CurveColor to set the color of the curve.
    • (CurveColor takes an index argument to let you use different colors when a graph contains more than one curve.)
    • RGB is an Excel macro that lets you set red, green, and blue, in that order, to any value from 0 to 255 inclusive.

Attachments:
Creating Graphs 2 with colors.xlsm