Forum Discussion
Sort a columns by the rows
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.
In the top right corner of your chart - click the 3 dots - select Sort By - pick your choice - then you can sort either AZ or ZA
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
it still something wrong http://take.ms/MluGe
even after I click Sort By Method sort http://take.ms/3ac7c it still nothing
this is table http://take.ms/BqIQs
