About crosstab worksheets

A crosstab worksheet (short for cross-tabulated worksheet) relates two different sets of data and summarizes their interrelationship in terms of a third set of data. The figure below shows an example crosstab analyzing profit values for regions by department.

Figure 6-4 A crosstab worksheet

Description of the illustration ty_ct.gif

Key to figure:
a. Top axis, containing the Region item.
b. Left axis, containing the Department item.
c. Data points, containing profit sum figures for each region in each department.

The region and department items are displayed as rows and columns on the crosstab. Each row and column intersection shows a data point, which in this case is the profit total for a particular region and a particular department.