Hi all,
I've set up a status-tracking chart which uses a simple SQL snippet.
I'm using the bar, rather than column, appearance category, because the group names are rather long and, in a column chart, EA simply skips group names which are too long. (The longest is only 47 characters, including spaces, but in order to get them all to display I have to stretch the chart over several screens, which kinda defeats the purpose of getting a quick overview.)
The problem is that the bar chart orders the groups in reverse alphabetical order. I want them in regular alphabetical order or, even better, I want to control the ordering from within my SQL snippet. After some testing, however, it appears that anything following an "order by" clause is simply ignored -- doesn't even have to be syntactically correct.
So: can I get EA to order the bars in proper alphabetical order?
Or, failing that, can I switch to the column category and get EA to wrap the group names? Or change the text orientation?
Cheers,
/Uffe
