X-axis order on a chart

[nowanda]

I've got a table like this:

grp num
<1 15
2 13
4 18
8 356
16 56
32 2
>32 86

But because it's a text field on a bar chart the x-axis
looks like this:

<1 >32 16 2 32 4 8

Instead of

<1 2 4 8 16 32 >32

Any tips on getting the order straight? Of course in Excel the graph works out just fine - but I'd prefer to have it interactive (i.e. direct from the database) than to have to go through Excel (import, export from and to Access!)

Thanks,
Nowanda

 

[Corticus]

Duplicate post, see:
http://216.92.17.166/board/viewtopic.php?topic=31692&forum=14&4

(just wanted to get this thing off the 'zero replies' page)