Specifying Category chart format options

Category chart format options control how the chart data points are displayed along the category axis.

1. On the Format page of the New Chart wizard, select Category in the tree.
   The Category options are displayed.
2. Specify what data series is used to sort the data points along the category axis in the Order By list.
3. If you specified Values in the Order By list, select the value column that you want to use.
4. Specify whether the data points along the category axis are sorted ascending or descending in the Order list.
5. Select what type of cutoff that is used to restrict the display of data points along the category axis in the Type list.
   Valid options include:

   • No Cutoff - No cutoff is used to restrict the category axis data points.
   • Item Number - Only the specified number of data points are displayed.
   • Data Value(Less) - Only rows that contain values that are larger than the specified value are displayed.
   • Data Value(More) - Only rows that contain values that are smaller than the specified value are displayed.
   • Percentage(Less) - Only rows that contain values that are more than the specified percentage of the data range.
   • Percentage(More) - Only rows that contain values that are less than the specified percentage of the data range.
6. Specify the value column that you want to use to determine cutoff in the Value Series list.
7. Specify the value that you want to use to determine the cutoff in the Value field.
8. Select the Visible check box to make excluded data points visible.
9. Specify what label is displayed with the excluded data points in the Label field.