Hi,
I have a excel filter chart on which the "X" (horizontal) axis consists of weeknumber/year for example 14/2009. When I try to sort these on the pivot table (right click on the pivot table and sort) they still remain in a random sequence. This happends even when I try to sort them in the source data. I formatted the source column as a number with no decimals and tried again - but no luck.
Any help is appreciated.
Thanks.