Stack ascending order not working

[srat123]

Right stacked graph: Sorting of regions wrong
The blocks have to be sorted like this with NAFTA on teh top of teh stack and APAC as teh bottiom most.. i.e in ascending order like this
green - NAFTA
yellow - JAPAN
orange - EUROPE
blue - APAC


I have tried to give ascending order in chart expert but there is a problem . APAC (blue color)doesnt come as the first stack but comes as the last stack. Other regions have been sorted in ascending. Now if i give it in descending order, then it works fine.
How can I make the blue stack also appear in ascending order.

PLease give your suggestions !!! I need to fix this issue immediately.

 

[lbass]

Please see thread149-1593810.

-LB

 

[srat123]

There are zero values for certain stacks and @HIDE_ZERO macro is in place... SO my zero value stacks are not visible.. I tried enabling it but still dint fix it. BAsically the order of arrangement of my stack has changed.

 

[lbass]

Are you using Crystal Reports? I don't know what you mean by a @hide_zero macro. The thread I referenced makes the only suggestion I know of to address this issue.

-LB