Pivot Table Month Order

  • Thread starter Thread starter drangonfly2664
  • Start date Start date
D

drangonfly2664

The month order as a column heading is in the correct order except that Sep
is at the very end rather than after Aug. I'm new at working with pivot
tables and have been unsuccessful in researching and correcting the problem.

Thanks.
 
The problem is you are using month names, which Excel, naturally sorts into
alphabetical order. Your choices are:

1. Use month numbers -- at least they will sort properly.
2. Use the full date, which you can format to display just the month name.
You the display that you want. and your results will be sorted properly.

Regards,
Fred
 
Alternatively, Tools>Options>Custom Lists and create a list of Months in the
order you want them.
Then set the Pt to Sort Ascending on Month and it will use the Custom List
order.

--
Regards
Roger Govier

Fred Smith said:
The problem is you are using month names, which Excel, naturally sorts
into alphabetical order. Your choices are:

1. Use month numbers -- at least they will sort properly.
2. Use the full date, which you can format to display just the month name.
You the display that you want. and your results will be sorted properly.

Regards,
Fred




__________ Information from ESET Smart Security, version of virus
signature database 4738 (20100102) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4738 (20100102) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top