The following steps describe how to set columns order for Vertical Line Graph in a document in MicroStrategy 10. Take MicroStrategy Tutorial project for an example.
Create a report as the dataset for the document. Insert attribute [Year] [Month] to row, and add attribute [Category] metric [Profit] to column.
Go to menu Data -> Advanced Sorting..., go to columns tab, add a sort setting, and choose Sort By to metric [Profit], Criteria to "2012, Jan 2012" (which is the data in the first line), Order to Descending. Click OK and run the report. The sorting and grid result is as follows.
Based on the dataset, create a document. Insert a graph and edit the graph based on your needs. The graph document sorting would be the same with the dataset. The result is as below.
