Create a custom sort order of items on a Pivot Chart
I'm looking to create a custom sort list in a pivot table. I want to enable the ability to define a sort order for a list of products so that when a user selects them, they will appear in an order based on priority. For example,
For the following products, I have numbered them in the order of priority.
3. Mango Punch
5. Classic Margarita
But when I select these products, they do not appear in this order. From left to right, they currently appear in the following order
How do I enable it so that I can predetermine an order by which a product appears on a pivot chart. As the screen shot below illustrates, the order is not what I would like. It's currently displaying in the following order 5, 2, 1, 4, 3.