Series Categories not in order

K

Kim

I have set the Series order in the chart option for a bar chart
but for the categories with value = 0, those categories automatically go to
the bottom. this is problematic as i need to insert series line and for those
categories, the lines start at the bottom of the bars
Why they are not in order?
 
Top