Question about Chart Axis

[jcao0000]

I'm currently working on a chart which x-axis shows the weeknum and y-axis shows the sales value.
But if the time period crosses over a year (for example: 2006-week 40 to 2007-week 12), how can I show the week number in the right order on axis without showing the real date? Now it always shows 1,2,3,...12,40,41...52.

Thanks in advance for any help!

 

[lbass]

I think you would have to use a formula that resulted in the year followed by the week number, just as you indicated was used for your record selection criteria. I think the only way you could get the desired display (without the year) would be to then manually select each x-axis value and change it--but this solution is only good for that particular date range.

-LB