Date format in chart axis 1

[mdcson]

thread149-1393583

In referencing the above closed thread, I realized I had the exact same issue as the poster. My goal is to graph numbers by dates with dates being on the x-axis. The format I wish to achieve is, for example, Dec-10, Jan-11, Feb-11, etc.

I figured out how to do this by using the following formula:
cstr({@ToDate},"MMM-yy") where {@ToDate}is a formula that simply converts the incoming data into a date format.

This formula is working and giving me the format I need, however, the chart is arranging the dates on the x-axis in alphabetical order. The solution given to the poster is confusing to me as it was to them, hence my posting here. How do I correct this issue and get the dates to show up in date order?

 

[lbass]

If you go to the chart type tab and choose "Numeric Axis" chart, options on the right include date axis bar chart, date axis line chart, etc. Choose one, and then select the x-axis label->right click->group x axis options->numbers tab->category: Date->Type: Feb-02.

-LB