MS Chart ASP.Net Custom sorting

Question

I'm using c# with ASP.net using MS Chart...(System.Web.UI.DataVisualization.Charting)...as a bar chart with a 2 axis horizontal orientation (please see the attached screenshot)...

I am wanting to have the Y axis items displayed in this order: Item B, Item C, Item A, Item D. (Not alphabetically). I have looked at links like "Using Microsoft's Chart Controls In An ASP.NET Application: Sorting and Filtering Chart Data" - (http://www.4guysfromrolla.com/articles/092309-1.aspx) and can see that it is possible to an IComparer class for custom sorting, but I can't seem to get the code to work. I have already specified in the SQL server based DataTable the sort order, but the chart seems to be ignoring that and sorting these names it's own way.

Can anyone please help?

Thanks