As you mentioned in your post, the categorical axis orders the items in the way they are passed to it. In order to sort them in a specific manner, you need to sort the data source first.
It is a bit more complicated in your scenario having two or more series. The approach you have tried with having another series just to be sure that all the categories are being displayed might work. You said that the bars are clustered. Have you tried setting the Combine
modes of your series to Stack
? This way the bars should look fine and well positioned. Default value of series' Combine mode is Cluster.
If this does not help, could you give us a bit more information about your scenario so we can think of a better solution.
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.