https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3762#M1590 I think you need to be a little more specific in your question. Your statement about the order in the data sets suggests you might want something like O R D E B Y. I suspect that the axis declarations don't allow sequencing other than collating sequence or reverse collating sequence.<BR /> <BR /> I will look at that, and see whether it can be done. Meantime, please provide an example of the order required.<BR /> <BR /> Kind regards<BR /> <BR /> David Tue, 10 Jul 2007 06:49:20 GMT deleted_user 2007-07-10T06:49:20Z https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3761#M1589 Hi there,<BR /> I am using gbarline to draw some graphs.<BR /> I want the X axis of the bar chart to get all the possible values of the discrete character variable but in that specific order in the datasets. How can I do that?<BR /> <BR /> Thank you so much. Appreciate it. Mon, 09 Jul 2007 20:02:56 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3761#M1589 deleted_user 2007-07-09T20:02:56Z https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3762#M1590 I think you need to be a little more specific in your question. Your statement about the order in the data sets suggests you might want something like O R D E B Y. I suspect that the axis declarations don't allow sequencing other than collating sequence or reverse collating sequence.<BR /> <BR /> I will look at that, and see whether it can be done. Meantime, please provide an example of the order required.<BR /> <BR /> Kind regards<BR /> <BR /> David Tue, 10 Jul 2007 06:49:20 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3762#M1590 deleted_user 2007-07-10T06:49:20Z https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3763#M1591 This may call for some exquisite SAS trickery! <BR /> <BR /> Some possibilities include adding a new variable that allows explicit ordering and then:<BR /> <BR /> Applying a format to that variable to get the appropriate label on the chart or, using an axis statement with tick mark labels e.g. value=(t=1 'ValueName1' t=2 'ValueName2') etc.<BR /> <BR /> wd Tue, 10 Jul 2007 12:46:42 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/axis-of-the-graph/m-p/3763#M1591 Bill 2007-07-10T12:46:42Z