Sorting column in chart

[jzacharias]

I have a chart that I can't figure out how to sort by my key_ID field. My other chart sorted properly, but this one won't. If I upload my database, would someone try and see what is wrong...spent a whole day messing with it and can't make it work.

 

[JHB]

Then upload you database, how do you want it sorted?

 

[jzacharias]

I would like the Deputy Totals by Month (Datasheet View) to be sorted by Shift_ID which should list the shifts in the order of Days, Afternoons, Midnights, SRU, STU, OTD. The only way I can make it work is without setting the order by Shift_ID and it ends up in alphabetical order. I have to try and get the database smaller...It's at 2.5Mb

 

[jzacharias]

Here is the file

 

[JHB]

Are you thinking of sorted in this way?

 

[jzacharias]

Yes... The report section works fine, I just can't get the chart to sort the same way.

 

[JHB]

Then I think it is the below you want.

 

[jzacharias]

How was that achieved?

 

[jzacharias]

I can't thank you enough. Although I don't comprehend what is going on behind the scenes to make it work, I am thrilled it works. I just can't believe it has to be so complicated to sort.

 

[JHB]

Yes it is a little bit tricky - you can't get it showed up sorted on this way you want, because the Shift_id is not at the x-axis.
Therefore, you first need to gather Shift_id and Shift together in the same field, like "001Day".
And since you can not change the field names in a query, you need to first create a temporary table, where you can change field names back to "Day".

 

[jzacharias]

In another report, I created charts and used shift_ID to sort which worked fine. I don't understand the difference with this chart. I am a beginner with access. Curious about the click event on the menu. It didn't pull up the report and not sure how the VBA plays a role in the report because when I transferred your query and table to my copy it worked fine without the VBA

 

[JHB]

You have to use the VBA behind the button.
The chart here is showing per month with the shift. I only saw one other chart in you database, and here was only the shift on the x-axis, (not first sorted on month).
Then show the chart.

 

[jzacharias]

Ok...I understand. Thank you