Jet Chart x-axis label sorting for Stacked Bar

JSmydo

Hi

I have a multi-series stacked bar chart in apex v20.2 where x-axis labels are dynamically created. My problem is that the x-axis values are strings - they can be numeric values, string values or range representations of numerics e.g. < 100, 100-200 etc., so ordering can't be done properly for pseudo numeric x-values. I necessarily have to have the 'Fill Gaps in Chart Data' switched on to have a sensible graph but it then limits the ordering to be either by the label or value - neither of which will order the way I want.

Is there any way that I can force an ordering of a custom column that already exist in the series query?

Cheers

John