You should be able to just sort using the sort order set in the sort tab of the chart properties. If interactive sort is allowed in that tab, double clicking a header will sort the column, flipping asc / desc sort order.
However, there are some chart expression functions, e.g. namely the chart inter record functions like rangesum(), that disable sort of y-values. Do you use any of these functions?