Access 2007 Charts

[access_viper]

Hello again.

I have a simple query with the following results:

Above 4
Average 10
Below 5

Whenever I try to insert/add a chart (whether it be a bar, line , pie...etc), the chart does not display correctly. Instead of seeing my values, I see:

                           Totals
        _____________________________
North                                                    

West                                                     

East  _____________________________
         0                    50                        100

I do not get an error when I import the query (or even when I set the table to be the source). But when I preview the chart and when I try to manually edit it from the report, I get the above.

Is this a bug in Access 2007 or am I doing something wrong?


Thanks in advance.

 

[Rabbie]

It would be helpful if you give us a little more info about what you have done and also post your DB so we can help you

 

[access_viper]

Sorry for the delay...finals at school.

Anyway, I figured out what the problem was. Access by default, was expecting a more complex chart, thus the values it needed were not there. I slimmed down its values and the chart works perfectly.

Thanks!