Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Month Order
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Month Order
The problem is you are using month names, which Excel, naturally sorts into
alphabetical order. Your choices a 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 "drangonfly2664" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Month Order
Alternatively, ToolsOptionsCustom 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" wrote in message ... The problem is you are using month names, which Excel, naturally sorts into alphabetical order. Your choices a 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 "drangonfly2664" wrote in message ... 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. __________ Information from ESET Smart Security, version of virus signature database 4738 (20100102) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4738 (20100102) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Pivot table sort order | Excel Worksheet Functions | |||
Sum Order and Vendor Orders from Pivot Table for Given Month | Excel Worksheet Functions | |||
Pivot Table Order Not Functioning | Excel Discussion (Misc queries) | |||
Pivot Table out of order | Excel Discussion (Misc queries) |