How can I turn off the automatic ordering of the data in Pivot Cha
 

I have some data, which I would like to rearrange in the chart, but it's
automatically re-ordering it. I have tried manually re-ordering the data,
but that's not helping. The Pivot chart seems to automatically override what
order I put the data in, and charting it as it wants. I have tried
unchecking the Automatic Formatting, but no change. Help?