HomeTechniques and TipsVBA Programming with @RISKPlacing Graphs in an Existing Worksheet with VBA

10.10. 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

Downloads

This page was: Helpful | Not Helpful