Print Friendly and PDF

Export Chart Images to a File

Ryan Roper -

This is a simple reservoir operations model that calculates monthly inflows and withdrawals from a reservoir using a monthly time step. It is used to illustrate how an Excel VBA macro can be used to automatically generate plot image files when results are exported from GoldSim to an Excel file. Run the model and note that four image files are generated showing plot results (e.g. streamflow, reservoir volume and inflow/outflow rates, etc.).

Experience Level:

Advanced

Download the Model File:

Tags:

  • VBA
  • export
  • excel
  • spreadsheet
  • plot
  • macro
Have more questions? Submit a request

Comments