Microsoft Office Tutorials and References
In Depth Information
Creating Multiple Scenarios
A scenario summary displays your original data along with the data stored in
each scenario in a table. By viewing a scenario summary, you can see how
the values of your spreadsheet can change depending on the scenario, as
shown in Figure 9-20.
Figure 9-20:
A scenario
summary
compares
your original
data with
all the data
from your
scenarios in
an easy-to-
read chart.
To create a scenario summary on a separate sheet in your workbook, follow
these steps:
1. Click the Data tab.
2. Click the What-If Analysis icon in the Data Tools group.
A pull-down menu appears.
3. Choose Scenario Manager.
The Scenario Manager dialog box appears.
4. Click Summary.
The Scenario Summary dialog box appears, as shown in Figure 9-21.
Figure 9-21:
Define the
type of
summary to
create.
 
Search JabSto ::




Custom Search