CR10 - Stacked bar chart - want to stack in a specified order

[shera4111]

Hello,

I have a stacked bar chart which tracks counts of work items by state and employee... so it looks like this:

count(done) count(done) count(done)
count(started) count(started) count(started)
count(new) count(new) count(new)
emp1 emp2 emp3

The chart is set up like this:
-On change of: Employee (Ascending)
Status (Specified)
-Show Values: count of Status

I'd like for Crystal to stack the bars in the order I want... for example, with 'done' on the bottom, 'started' in the middle, and 'new' at the top. I thought that was what specifying the order for the status column in the 'on change of' would do. Seems not to be working.

Any thoughts would be appreciated.
shera4111

 

[lbass]

I just tested this and specified order worked, but the order is specified from the bottom up, so if you want done on the bottom and new at the top, enter the specified order as done, started, new.

-LB

 

[samldanach]

I'm having a very similar problem.

Using Crystal XI:

If I go with the original poster's data, it all works fine IF the first employee has work items in each of the three categories. However, if the first employee has no 'started' items, then the order would come out Done, New, Started.

It appears that the group isn't added to the order until data for it appears, working bottom to top, left to right.

This is particularly awkward for me, as I'm doing the chart in the group headers, and I would like for the colors to be consistent across all the charts.