Crystal Chart and Month Number vs. Month Name
Posted on 2006-10-20
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.