Bar Chart Sorting issue

[#1]

I have a bar chart that depicts the close ratio for each GEO over the past 12 months.  The formula is calculating the close rate correctly, and depicting it correctly, but I can't get the sort order to work.  I am displaying these rates over a field called NumFYMonth.  This is just a formula within the script that merges the FY number and the month number.  I need this to sort by month within fiscal year, and then by fiscal year, but I can't seem to get it to work.  Any help would be appreciated.  Right now it is sorting largest to smallest because it is taking the FYMo number as a whole number 201112 instead of 2011 12.  So, I just need help figuring out how to get it to ignore this number and sort the way that I want it to.

Thanks

[nagaiank]

Either format your NumFYMonth in the pattern YYYYMM or you may use the calculated dimension in the chart with the expression

=Left(YM,4) & Num(Mid(YM,5),'00')

and set the sort order to 'Numeric Value Ascending'

Hope this helps.