I am trying to create a graph that displays the "top 10" co-locations for our business. The graph works fine. I am having trouble having only the location code show up on the Y-Axis. Instead it shows the rank followed by the value (e.g. 1: 12, 2: 34, 3: 28, etc.). How do I get the rank not to appear? I am using WF 7.6.4. The code is below:

TABLE FILE COLO_COL
SUM COLO_PROFIT
RANKED BY TOTAL HIGHEST 10 COLO_PROFIT NOPRINT
BY COLO_CD
ON TABLE HOLD AS COLO_PROFIT1
END

GRAPH FILE COLO_PROFIT1
PRINT COLO_PROFIT
BY RANK NOPRINT
BY COLO_CD
END

bp,

You can't use a double sort in a graph. I know it is very annoying.

Here is an example that I posted that should get you around your problem:
Changing a Chart Legend Based on Data

In your case, you would sort by RANK but use the COLO_CD in your legend. I have used this technique a number of times and it works very well and is not too complex.

Good luck!