Adding Cross-Tab Charts

The Cross-Tab chart is similar to the Group chart because it takes one of the fields that the cross-tab object is grouped on and plots one of its summary fields. The related dialog box is shown in Figure 10-6.

Figure 10-6. The cross-tab options of the Data tab.

The On Change Of dropdown box lists the two outer most group fields for the cross-tab object. If you have multiple fields listed for either the row or column setting, then the second and later fields are ignored and can’t be used. The field selected in the dropdown box determines when a new element is drawn. Thus, the cross-tab chart can have either one element per row or per column.

The Show dropdown box, lets you select the summary field to plot. This serves the same purpose as the Show Value setting with the Advanced button. However, the Advanced setting lets you select multiple fields and the Cross-Tab settings only let you select one field.

The middle dropdown box, titled Subdivided By, lets you create a data set that is similar to having multiple fields in the Evaluate setting of the Advanced options.