Using Calculated Fields with Chart Coordinates

This example uses calculated fields with chart coordinates. Assume you must set the following coordinates:

• 0-200

• 200-999

• 1000-4999

• 5000-24999

• 25000+

To use calculated fields with chart coordinates

1. Create a calculated field that contains the one relevant value of the five coordinate values.

   For example, if the record contains a value of 500, then the calculated field value is 200-999.

2. To view the coordinates in the chart in the order you require, create a list of values that contains the following values:

   • 0-200

   • 200-999

   • 1000-4999

   • 5000-24999

   • 25000+