Sorting x-axis values
I'm trying to do a simple descending sort for number values on the x-axis (so just reverse the x-axis values).
However, this does not seem to work as the values stay in ascending order. I figured out the problem is that I am using a scatter plot, since the sorting works fine with e.g. a line chart. Problem is that a line chart handles the x-axis values as text, so the interval is the same regardless of the x-axis values.
Is there a known workaround for sorting values on a scatter plot?