charts again!

Just can't satay away!
This is a bit tricky to get oneÆs head around.. starting from this query I get a table which can be saved û
AgeSex.db |Age |Male |
|>16,<35, calc count all |check Male |
|>36, <65, calc count all |check Male |
|>66,<75, calc count all |check Male |
|>76,<95, calc count all |check Male |

and the table produces the following information û

Male Age count

M 1
M 2
M 9
M 36

Now, as the table has been saved I want to use it to produce a pie or
column chart showing the totals in the various age groups - BUT I cannot get it to annotate the totals to show what (count number) relates to what (agegroup).
Okay you say, so stick some separate labels on the report or colour code the
info.. but thatÆs no good because the table order of the four counts changes
as itÆs shown in ascending order û ie if I suddenly get a boat load of >16,<35 males then that count number will be at the bottom of the table.
Any ideas? rt

AI, thanks for the reply. But, maybe because it's Monday and I'm not yet functioning it does not seem yo want to work any better than the original. So, could you run this bit of code past me in full blown explanation mode -
calc "16..35" as Index -
in the hope I can see what you're about.
Thanks rt

Well it must be Tuesday, since I have just literally looked at this again and all is now perfectly clear!! Maybe we (I?) ought to consider taking Monday's out of the week.rt

AgeSex.db | Age                                               | Male |
          | >15, <=35, calc count all, calc "16..35" as Index | Male |
          | >35, <=65, calc count all, calc "36..65" as Index | Male |
          | >65, <=75, calc count all, calc "66..75" as Index | Male |
          | >75, <=95, calc count all, calc "76..95" as Index | Male |

-Al.


[This message has been edited by A. I. Breveleri (edited March 16, 2001).]