Forum Discussion
Bar chart not sorting correctly
Very good morning, I am facing troubles sorting my bar chart. Below is my data from Excel. And here is the result. I am sure this is due to the intervals. Any trick to sort from low to hi...
Anonymous ,
Create one calculated column for sorting:
Sorting = SWITCH('Table[Range],"25000-100000",1,"100000-500000",2,"500000-1000000",3,">1000000",4)
Then go to Data View --> Then select the range column --> click on "Sort by Column" option then choose Sorting column which is created above. Then yor Range column will get sorted by Sorting column order.
Anonymous ,
Create one calculated column for sorting:
Sorting = SWITCH('Table[Range],"25000-100000",1,"100000-500000",2,"500000-1000000",3,">1000000",4)
Then go to Data View --> Then select the range column --> click on "Sort by Column" option then choose Sorting column which is created above. Then yor Range column will get sorted by Sorting column order.
Then go to Data View --> Then select the range column --> click on "Sort by Column" option then choose Sorting column which is created above. Then yor Range column will get sorted by Sorting column order.