What are axis items?

Axis items are items that appear in the workbook window in:

• the page axis

• the top axis

• the left axis

Typically, axis items have a relatively few discrete values. You use axis items to identify particular data values.

For example, if a crosstab worksheet shows sales figures, it might include Year as the top axis and Region as the left axis. You can then use the axis items to see the sales of a particular region in a particular year. In the figure below, Department item is on the page axis, Year is on the top axis, and Region is on the left axis.

Figure 5-11 A crosstab worksheet showing page axis, left axis, and top axis

Description of the illustration ct.gif

Key to figure:
a. The page axis (Page Items area).
b. The top axis.
c. The left axis.
d. Data points.