I think I have found what is causing this problem. The data that I am getting from db and binding to chart looks like that:
Date
Case Count
Group Column
05/01/2009
6
Female
05/01/2009 4 Male
05/01/2009 8 Other
05/01/2009 11 Unknown
06/01/2009 4 Female
06/01/2009 3 Male
06/01/2009 3 Unknown
07/01/2009 6 Female
07/01/2009 6 Male
07/01/2009 5 Other
07/01/2009
5
Unknown
and I am using RadChart.DataGroupColumn = "GroupColumn" property so chart will create series for me automatically. It leads to inconsistency of series position as you can see from attached "wrongPosition.png" file.
So I decided to manually inject a record for 06/01/2009 that will have some values for the "Other" gender so 06/01/200 will not miss 4th series value:
Date
Case Count
Group Column
05/01/2009
6
Female
05/01/2009 4 Male
05/01/2009 8 Other
05/01/2009 11 Unknown
06/01/2009 4 Female
06/01/2009 3 Male
06/01/2009 8 Other
06/01/2009 3 Unknown
07/01/2009 6 Female
07/01/2009 6 Male
07/01/2009 5 Other
07/01/2009 5 Unknown
and result is correct. All series are consistently positioned in graph as you can see from attached "rightPosition.png" file. Furthermore if will inject a record with values:
06/01/2009 0 Other
it is creating chart correctly.
Is it a known bug? Is there an easy way of fixing this?