Let's say, for example, I have 3 variables. Date, week and sales.

Date is dd/mm/yyyy, week is 'w' (i.e. 1:52), sales is a value in $$.

I want to do a bar view of sales split by week. I make sure the data is sorted by Date so it is oldest to newest. Here's the issue. The data spans the end of 2010 and the first few weeks of 2011. So the data sorts fine, but then when I plot using the week field the chart sorts the week field as 1-52. So my data on the x axis is something like 1,2,3, 49, 50, 51, 52 instead of 49, 50, 51, 52, 1, 2, 3 (because that is the 49:52nd weeks of 2010 and the 1:3rd weeks of 2011).

Any ideas on how to fix this?

Thanks in advance.

GPC