Chart date out of order

[Former Member]

Post Author: sboyd@dynamicaviation.com

CA Forum: Charts and Graphs

I have a chart that is grouped on the date by month. The data in the main crosstab report is in the correct order but the dates are grouped incorrectly in the graph. The graph is listing in this order:

1/2007, 10/2007,11/2007, 2/2007,3/2007....

It's picking up the first number as the sort order instead of the date. I've checked by date format and everything is correct in my report. What can I change to get the chart date order correct?

[Former Member]

Post Author: qcheng

CA Forum: Charts and Graphs

Right click the chart > select "Chart Expert" > "Data" Tab > Select the "On Change Of" field > Click "Order" button > select "in original order". Your group will be in right order now.