By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

pivot chart question

P: 12
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.
Dec 11 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,660
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).
Dec 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.