Configuring Siebel Business Applications > Configuring Special-Purpose Applets > Customizing a Chart Applet >

Limiting and Sorting Axis Points

You can limit the number of X-axis or Z-axis labels to a predefined number. The X-axis defines the category and the Z-axis defines the series. You can use this feature to display only the N highest or N lowest values for a field or calculated Y value. For example, to display the 10 highest revenue accounts, you can chart the Revenue field in descending order and limit the X-axis to 10 data points.

To limit and sort axis points

1. Complete Step 1 through Step 5.
2. In the Object Explorer, expand the Chart tree, and then click Chart Element.
3. In the Chart Elements list, define properties of the axis label chart element, using values from the following table.

   Property	Description
   Divisions	Defines the X-axis or the Z-axis. Enter an integer to limit the number of X-axis or Z-axis labels. Siebel CRM limits the number of labels it displays to the number you enter. Note the following: Make sure the AxisId property is equal to XAxis or ZAxis. Make sure the Type property is equal to AxisLabel.
   Sort Specification	Defines the Y-axis. Enter Ascending or Descending. Note the following: Make sure the AxisId property is equal to YAxis. Make sure the Type property is equal to AxisLabel.

Sorting the Y-Axis

You can sort the Y-axis.

To sort the Y-axis

• Create a sort specification on the Y-axis.

  This sort specification is independent of limiting the number of X-axis or Z-axis divisions. A sort specification on Y orders the data points regardless of if you limit or do not limit the display to the first N points. However, you cannot set a number of X-axis or Z-axis divisions without also setting a sort specification on Y.

Sorting on the X-Axis or Z-Axis

You can sort the X-axis or Z-axis labels.

To sort on the X-axis or Z-axis

1. Complete Step 1 through Step 5.
2. In the Object Explorer, expand the Chart tree, and then click Chart Element.
3. Set the Sort Specification of the chart element in the X-axis or Z-axis label.

   For example, if the X-axis displays country names, then sort the names so that they are in alphabetical order, from left to right. This is different from sorting on Y-axis values from a field in a business component or function according to the field where these values are numeric.