chart not sorting alphabetically (1 Viewer)

[DaRTHY]

Hello my friends;

I made a "Stacked Column Chart" and there is 5 different Axises. When I was creating my query, first of all built a new table. Because I do not want to see Axis as an alphabetically. On my query it is working perfectly. But when I create new Chart, Access is sorting automatically for me. :banghead::banghead:

Question is : How can i stop it ? Does anyone have an idea(s) ? I checked almost all buttons or Chart-Options. Hope so you can help me.

Thanks.

 

[JHB]

Could you show a printscreen of what you get, then I don't know what you mean by 5 different axes. Also show how you want it looks like.
And maybe post a sample database.

 

[boerbende]

I think I know what you mean. I also called my columns 0_blabla to force them coming up as first for example. But I cannot reproduce it now.

Maybe this link can help you?

https://support.office.com/en-us/ar...9a4d-13f57e6e6df5?ui=en-US&rs=en-US&ad=US#bm3