I am trying to sort a bar chart by data, but the category labels are not rearranging with the data so the display is wrong with the option selected.
Screenshot with sort by data unchecked, the amounts on each bar correspond to the category code on the left.
Screenshot with sort by data checked, the bars are rearranged but the category labels stay in the same place.