Trying to understand PIVOT TABLE pivot fields order, and change?

[logandiana]

What determines the order of the columns headings from left to right? In this example it appears to be alphabetical, but is that always the case? Is there any set rule to this? Could have sworn I'd seen an example where this wasn't the case before.
Is there a way to change the order using VBA?

Sum of Number	Color
Date	blue	green	orange	red	yellow	Grand Total
10/2/2017				11		11
10/3/2017	17					17
10/4/2017				14		14
10/5/2017			16			16
10/6/2017					11	11
10/7/2017					10	10
10/8/2017	14					14
10/9/2017				14		14
10/10/2017					17	17
10/11/2017		13				13
10/12/2017		16				16
10/13/2017		19				19
10/14/2017		13				13
10/15/2017				15		15
10/16/2017					17	17
10/17/2017					17	17
10/18/2017	13					13
10/19/2017	10					10
10/20/2017				11		11
10/21/2017	10					10
10/22/2017			12			12
Grand Total	64	61	28	65	72	290

<tbody>
</tbody>

 

[RoryA]

By default it will be alphabetical but you can sort it pretty much any way you want, including an entirely manual order, either in VBA or in Excel itself. How are you trying to sort it?

 

[logandiana]

This was just an example, but lets say I'd like to use VBA to sort it in a specific order bases on names. For instance lets say I always want the order Red, Orange, Yellow, Green, Blue.

 

[RoryA]

You don't actually need VBA for that. If you create a custom list in that order, you can sort the field using that list.

 

[logandiana]

You don't actually need VBA for that. If you create a custom list in that order, you can sort the field using that list.

Can you explain how to do this?