I am trying to complete a pivot chart, but the data is autosorting. I verified that the autosort is set to manual. For example:
Week-------------------Units----------Hours
Feb week 1-------------5---------------6
Feb week 2-------------7---------------8
Mar week 1-------------9---------------10
Mar week 2-------------11-------------12
April week 1------------13-------------14
April week 2------------15-------------16
This pivottable would autosort week in the following order:
April week 1
April week 2
Feb week 1
Feb week 2
Mar week 1
Mar week 2
How can this be canceled? Thanks for your help!
Bookmarks