Sorting on spreadsheet columns
You can sort the bar chart view according to the data in a particular column. For example, if you have a column displaying task cost, you might want to sort the view from the most expensive task to the least expensive, or vice versa.
To sort the current view according to the data in a particular column, right-click the column heading then select Sort Ascending or Sort Descending as appropriate. The view is then sorted on the column, overriding any sort/group specified in the view. When a view is sorted on a column, the Spreadsheet Column command on the Sort/Group dropdown in the View Data group on the View tab is selected.
To turn off spreadsheet sorting and revert to displaying tasks in the sort/group determined by the view, right-click the column heading, then select Sort by Default Ordering.
When you sort on a column displaying a fixed setting such as code
Adding columns to the spreadsheet
Removing columns from the spreadsheet