Hi Everyone,

I have a Bar chart , wherein I have some monthly data to be displayed.Xaxis shows month and Y axis indicates count.I want data to be organized from Jan-dec.If I use the order feature of then months are ordered in alphabetical order and If I use month no then how do display Jan.Feb...Dec on axis.

I want to specify my own sort order for x axis? Any idea?

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

http://forums.informationbuild...731008331#5731008331
Check out this previous post.

Shivani...

You can use the ACROSS command.....i think this will help you....

Shivani, I would recommend to use a 'BY NOPRINT' solution here. Basically sort the chart by month and then by month # and NOPRINT the month #. This will sort the chart in Jan, Feb,...Dec order. Here is an example of the FEX structure:

GRAPH FILE ...
SUM ...
BY MONTH
BY MONTH_NUMBER NOPRINT
................
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
END

I used :
DEFINE FILE SQLOUT
NEW_DATE/YYMD = HDATE(PLANNED_START, 'YYMD');
GR_DATE/MtrYY = NEW_DATE ;
END

And then Across GR_DATE and it worked fine.

thanks for the responses.