Ascending a graph

C

Chad

Hello I have a bar graph that needs ascending. How would I do this? I tried
ascending in the query with no luck! I just did this a few weeks ago and cant
remember what I did. Please help...

Thanks,
Chad
 
C

Chad

I have no clue what your asking? I just want to ascend the data in my bar
graph because its all mixed up. I found out how I did it in my other graph I
made but thats not working. What I did was changed what was in the row source
to the query name and it used the ascending I had in my query but for some
reason its not working for this graph. Im getting all the right data but its
not in order from highest to lowest. I want to ascend Test. Here is the row
source data. Thanks!

SELECT [EMPLOYEE NAME],Sum([Test]) AS [SumOfTest] FROM
[qry_WeeklyAverageGraph] GROUP BY [EMPLOYEE NAME];
 
C

Chad

I figured it out! The reason I couldnt change the charts row source from the
formula that the chart produced to the query it was pulling info from was
that my querys order needed moved around then after I did that it used the
ascending I had for the Totals colum in my query. Weird? Anyway I got it!
Thanks....
 
Top