pivot chart question

[devagupt]

i have a form called get downtime data. WHen information is entered into it and the button "get downtime data" pressed , it displays the results of a query. WHen i view the query in pivot chart view , it only charts values which are over 1.Also , it displays only whole numbers and not decimal values like 2.3 etc.. I played with the scale tab in chart options and didnt get anywhere. I would like to display all values ( regardless of how small they are ) in all fields in the executed query on the chart.

QUestion 2 - When the supervisors click the button" get downitme data", they view the query results in the data sheet view and then they have to view it in pivot char view. Is there a way so everytime they click the " get downtime data" button , they would view the results in pivot chart view?

question 3 - Is there a way of sorting the chart in descending order? I dont see any DATA/Sort anywhere. I see only AZ and ZA and am not able to select the data area in the chart and sort it.

I am using MS Access 2002.

Kindly help. I have been working on this for the last 2 days and am not getting anwhere. All help is appreciated.

[NeoPa]

I can't help with most of your questions I'm afraid, but I do know that the ZA button normally sorts data in descending order (AZ is ascending obviously).