Forum Discussion
Solved
I have Timing Order but Chart is getting sort by value
Dear All, i have timing_hour 00-01 01-02 02-03 the data values, when i add this to chart order based on value hight value coming first , i want to make timing order anyway i can do ? ch...
bhanu_gautam
Super User
Super Usermohamedm You can create a calculated column that extracts the hour part of your timing_hour values.
SortOrder = VALUE(LEFT([timing_hour], 2))
After creating the SortOrder column, go back to the "Data" view.
Select the timing_hour column.
In the "Column tools" menu, click on "Sort by Column" and choose the SortOrder column.