Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

scenarios

ResolvedVersion 2003

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

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.