Selecting crosstab options
After creating a crosstab, use Advanced—Options to modify the crosstab appearance. You can choose whether or not to display blank rows and columns. For a graphical display of the table, you can set the maximum characters for axis labels, which determines whether the labels are complete, truncated, or hidden. Only pivoted and pie-style charts support showing a legend.
Optionally, you can set y-axis lower and upper limits for the crosstab chart according to crosstab maximum and minimum values. Setting these limits improves chart readability for a chart on which values appear too closely spaced. You can sort the results in ascending or descending order by measures.