Im new to charts in MS Access (2003), and i've recently created a bar chart that is pretty simple, however to get it the way i wanted i used the pivot function in the chart wizard. This works fine but i would like to order the bar chart from highest value (hence, tallest bar) to lowest. In the query the chart is based off of, i have the value's set in descending order, but it doesnt transfer to the chart once the pivots are done in the chart wizard. Here is the row source for in the properties for the chart.
SELECT [Resolution Code],Sum([CountOfCase Number1]) AS [SumOfCountOfCase Number1] FROM [QRYChart2Individual] GROUP BY [Resolution Code];
I would like it to order the chart by [CountOfCase Number1] in descending order, how would i achieve this?
Also, if i change to row source to directly from the query, it does put them in correct order because i have the query sorted correctly, however, the chart size mode then somehow is no longer in stretch, it crams it to the left. Even when i change the size mode to stretch, it doesnt change. And there are no null records in the query that would create this...
Thanks for your help.
SELECT [Resolution Code],Sum([CountOfCase Number1]) AS [SumOfCountOfCase Number1] FROM [QRYChart2Individual] GROUP BY [Resolution Code];
I would like it to order the chart by [CountOfCase Number1] in descending order, how would i achieve this?
Also, if i change to row source to directly from the query, it does put them in correct order because i have the query sorted correctly, however, the chart size mode then somehow is no longer in stretch, it crams it to the left. Even when i change the size mode to stretch, it doesnt change. And there are no null records in the query that would create this...
Thanks for your help.