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

 

[Russell Hauf]

Add a field to your table (call it Order, or something like that), and enter in values from 1 to the number of records. Then you can order your chart query by that field (that's what I do).

HTH,

Russell

 

[nowanda]

Silly Question - but how would one do that... The chart wizard doesn't seem to bring up any mention of sort order..

Can I change the properties after the chart has already been created?

Nowanda

 

[nowanda]

Found it!!

Works really nicely.. here is the SQL I used in the View..Properties Row Source field:

SELECT grph_mktb.test, grph_mktb.PercentR FROM grph_mktb ORDER BY grph_mktb.Order, grph_mktb.test;

Coolio!
Nowanda

 

[Russell Hauf]

Good! I hadn't yet seen your previous message anyway.

Cheers,

Russell