It doesn't seem possible to reverse the x-axis on charts if they are a date.
For example in a table you can make the most recent date appear first, but not in a chart. Adding a sort to the question makes no difference when the axis scale is set as a 'timeseries'.