Cross tab query pie graph....

[terre]

I have a pie graph based on a crosstab query
The Row Headings are 1-10, 11-20, 21+ (groupings of Numbers)

Thats all good but.....

The graph Legend shows up as

1-Oct
Nov-20
21+

I can't seem to change it.

Any one know the reason/solution?

Thanks

 

[dhookom]

Where do the Row Headings come from? Are they stored like that or do you use an expression? Can you change them to 1_10, 11_20,... or 1 to 10, 11 to 20,...?

Duane
Hook'D on Access
MS Access MVP

 

[terre]

They are stored as

No Response
0
1-10
11-20
21+

I have overcome the problem by using

1~10

etc

Terre