The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scenarios

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Scenarios

Resolved · Medium Priority · Version 2003

ReplyWed 9 Dec 2009, 16:00Delegate Mark said...

Scenarios

When switching between Scenario's is there a way to get an associated Graph/Chart to update automatically?

For upcoming training course dates see: Pricing & availability

ReplyWed 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

ReplyFri 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

Excel articles

· Advanced level training: Microsoft Excel and the Web
· Experience The Power Of PowerPivot
· What Are Sparklines In Excel 2010?
· How To Convert Text To Columns In Excel
· Working Together Is Easier Than Ever With Excel 2010

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions