Mark has attended:
Excel Advanced course
Scenarios
When switching between Scenario's is there a way to get an associated Graph/Chart to update automatically?
RE: Scenarios
Hi Mark
Thank you for your question. I'll try out some scenarios and get back to you with some suggestions.
Kind regards,
Andrew
RE: Scenarios
Hi Mark
Thank you for your question. I've checked and Excel will update the Chart once the Scenario manager dialog box is closed. To make it easier for a recipient viewing the scenarios you may wish to add macros (possibly connected to buttons) that switch scenarios so both the data and chart refresh when the scenario is changed.
I hope this helps. Do let us know if you have any further questions.
Kind regards,
Andrew