Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table and Pivot Table dates are not in correct order ls Charts and Charting in Excel 3 July 14th 09 04:02 PM
Pivot table sort order ajnmx Excel Worksheet Functions 1 March 27th 07 10:39 PM
Sum Order and Vendor Orders from Pivot Table for Given Month vstar Excel Worksheet Functions 5 March 5th 07 04:18 AM
Pivot Table Order Not Functioning Jeff Eubanks Excel Discussion (Misc queries) 2 January 25th 07 09:40 PM
Pivot Table out of order reno Excel Discussion (Misc queries) 2 August 24th 06 08:42 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"