Crystal Chart and Month Number vs. Month Name

DataDesignIT
DataDesignIT used Ask the Experts™
on
Experts-

I have a chart which displays monthly information on the X axis.

If in Chart Expert, I show SUM values at the change of month number and City, it sequences my data correctly (1,2,3...), representing Jan, Feb, Mar.

If in Chart Expert I change the SUM to be at the change of month name and City, it 'incorrectly' sequences data by the month's alphabetical order (April, December, February, ...)

How can I order my X axis data by month number, but display the month name on the X axis. I see there's a Chart Sort Order with a formula option. Is there something here I can use? Also, the number of months will be dynamic at run-time. Sometimes it will be the first six months of the year, other times it will be the full 12 months.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
In the Chart expert when change the SUM to be at the change of month name and City
Select the Month field
Click ORDER button
Change the order choose SPECIFIED ORDER.  You will then be asked to provide the order.

mlmcc

Author

Commented:
Awesome! Thanks.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad i could help

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial