Click to See Complete Forum and Search --> : Grouping Order in Chart


jordanj2133
November 21st, 2006, 12:32 PM
Hi - I have 2 specified order groups. One is named @Groups: 0-12 Hours, 13-24 Hours, 1-2 Days, 2-3 Days, 3-5 Days, 5-10 Days, 10-20 Days, 20-30 Days, 1-6 Months, 6-12 Months, 12+ Months.

The next group, also in specified order, is NEXT_STAGE: SCH, QHD, RIH, ... etc etc.

I have a 3-D chart based on @Groups, NEXT_STAGE and a count of serial numbers. The chart arranges the @Groups to the following order: 0-12 Hours, 6-12 Months, 1-6 Months, 20-30 Days, 10-20 Days, 5-10 Days, 3-5 Days, 2-3 Days, 1-2 Days, 13-24 Hours, 12+Months.

I also have 3 other similar charts that are grouped by one more criteria, and they all have different orders for @Groups. Essentially I'm asking, is there a way to manually set the order in which my @Groups is printed on the axis of the chart?

Thank you.

-Jordan-