I've put the a year on the X axis but it does not come out in sorted order.
For example it shows:
2006, 2005, 2007, 2009, 2008
I changed the view that the chart was based on and made the first column the year and the X axis was sorted OK. Is this the best way to do it?