Need chart help

[kurting0]

I have a report that is populating from one query. It takes data for a year and groups it by month with the lost time for that month. I am comparing 3 years data 20005, 2006, and 2007. I have set the chart up and it looks good except that my time for each month goes into the data area as a "CountOf" lost time and all months are therefore one. I want to show the lost time for each month. I have tried right clicking on the field in the data area and Autocalc is set to Count, but everything else is grayed out and unavailable. How can I change this setting to just display the value? Thanks in advance for the help.

 

[Len Boorman]

Charts can be awkward

I suggest that you base you chart on a single simple query. You alrady have a query giving uou all the summations. Now use another query to query that query. You will need no summations cos that is already done and can alias the field names to something meaningful.

Sounds a bit of a waste of time but my experience says it makes the charting easier for Access and for you.

Len