Forum Discussion
Sort a columns by the rows
How to sort columns in column chart the same way like rows in table are situated http://take.ms/pWh6T
In order to be in such way http://take.ms/i9huS
b/c now it sorts columns by Alphabetic order http://take.ms/fCQyU
Create a Method Order Column - giving each Method its custom order number (you may have to use 01, 02... for first 9)
then concatenate the 2
Method Sort = [Method Order]&". "&[Method]
And use that column in the Chart
Don't Load the Data - click Edit
Then in the Query Editor - BEFORE you load - change the Data Type - the zeros should show up
Hopefully this takes care of it.
8 Replies
I want to maintain such order http://take.ms/zTGQd , not alphabetic
in order that columns http://take.ms/gctQ4 meet position of row in the table http://take.ms/9n0bxCreate a Method Order Column - giving each Method its custom order number (you may have to use 01, 02... for first 9)
then concatenate the 2
Method Sort = [Method Order]&". "&[Method]
And use that column in the Chart
