I have a very simple bar graph that I would like to sort by a different field than what it shows on the x-axis.

Variants of across using NOPRINT are what I try, but it just shows the first Across value without making any attempt to show the second field (in this case "TIME_OF")

GRAPH FILE LOGISTICS_STOP_CAPACITY_VW
SUM SCHEDULED AS 'Stops In Use' COMPUTE Capacity2/D12=CAPACITY - SCHEDULED; AS 'Stops Available'
ACROSS SORTER NOPRINT
ACROSS TIME_OF

In short...
I want it to sort the graph by the value in "SORTER" but want to show the "TIME_OF" value. Is this possible?

This message has been edited. Last edited by: Kerry,

Dialogue Manager. I've got a post in here somewhere on that. You have to create a SAVE file with the values that you want to use in your series and then do a -REPEAT loop in the graph stylesheet section to set up the series values.

Let me know if you can't find it.

Thank you for the quick reply, GinnyJakes.
I found some example code built over the car file that gives errors, it was doing something like writing to a save file in a sorted order then reading the values in and using the COLUMNS - AND keywords.

Do you have a better example? This language is all a little over my head.

This is solved.
I just had to use the
COLUMNS
FIELD1 AND FIELD2 AND FIELD3 ....

My fault for not asking the question properly.