Split Values in Graph

[Ice Rhino]

Hi Gurus

Here is a little minor problem I could do with some assistance on.

I have 49 fields in a data table that are under the value of 500. I have one value that nearly 1,000. Is there anyway to prioritize the graph to show the 500 on a reasonable scale and then just have a 500+ part on the top of the scale.

For example
0 - 100
101 - 200
201 - 300
301 - 400
401 -500
500+

Make Sense?

Toni

 

[Ice Rhino]

My thanks to you Pat for taking the time to answer. Off to write the function now

Cheers

Toni