98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scenarios
Scenarios
Resolved · Medium Priority · Version 2003
Wed 9 Dec 2009, 16:00Delegate Mark said...
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?
Wed 9 Dec 2009, 16:43Trainer Andrew said...
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
Fri 11 Dec 2009, 13:35Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |
