Non Alphabetical order of X-Axis label on a chart

[Juddy]

Hi,

I hope someone can help.

I have inserted a bar chart onto a form using a totals query. The query is grouped by days on stock, eg. '0-30', '30-60', '60-90' etc. which is therefore the labels on the x-axis.

The chart displays the correct data, however, the chart automatically displays the categories on the x-axis in alphabetical order... '0-30', '120-180', '30-60' etc.. Is there anyway to adjust this order to be eg. '0-30', '30-60', '60-90' etc?

Any idea if this is possible?

Thanks in advance
Kim

 

[JHB]

Either create a sort order field, or add the leading zeros.

'000-030', '030-060', '060-090', '090-120' etc?