Home → Techniques and Tips → VBA Programming with @RISK → Placing Graphs in an Existing Worksheet with VBA
Applies to:
@RISK 6.2.0 and later, Professional and Industrial Editions
I'm using the new RiskGraph object in VBA to create Excel-format graphs, but each one is on a separate sheet. How can I place them at a desired location in an existing sheet, and resize them as I wish?
Please see the attached model, which contains the appropriate VBA code. The "Graph Distribution JPG" button creates graphs as pictures; the "Graph Risk Result" graph creates a real Excel graph.
The Visual Basic for Applications references are customized for @RISK 7. For @RISK 6, you'll need to change them. See Setting References in Visual Basic.
last edited: 2017-05-31