Sort a month year chart by date

[thebigbadwolf]

Hello,

Here is a thing. I need to have a chart with a value per month year.

The problem is that the chart columns are not appearing sorted by the date but as their names.

For example for a date space 01/11/2011 - 01/02/2013 I need to have the following:

11/2011 - 12/2011 - 01/2012 - 02/2012 etc and I have 01/2012 - 01/2013 - 02/2012 - 02/2013 etc

Same problem when I use the function "Monthname" (first April, August, December etc)

Any suggestions?

 

[IanWaterman]

You have to change format to YYYY/MM

Ian