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

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.09 secs.