Microsoft Office Tutorials and References
In Depth Information
Analyzing data by using data tables
TIP If your target cells were laid out as a row, you would enter the address of the cell that
contains the value to be changed in the Row Input Cell box.
When you click OK, Excel fills in the results of the data table, using the replacement values
in cells C3:C5 to provide the values for cells D3:D5.
To create a two-variable data table, you lay your data out with one set of replacement
values as row headers and the other set as column headers. For example, you could build a
worksheet to calculate total revenue as a function of both rate increases and package count
In this case, you select the cell range C2:E5 and then, on the Data tab, click What-If Analysis
and then click Data Table to display the Data Table dialog box. Because you’re creating a
two-variable data table, you need to enter cell addresses for both the Column Input Cell
and Row Input Cell. In this case, the column input cell is B3, which represents the rate
increase, and the row input cell is B4, which contains the package count. When you click OK,
Excel creates your data table.