Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 05:27 PM
D Beals
 
Posts: n/a
Default pivot table dates are out of order how do I correct them

My pivot table data is appearing with the dates out of order. How do I get
the dates to appear in order?

1/1/05 1st date
1/5/05 2nd date
1/2/05 third date

  #2   Report Post  
Old May 18th 05, 05:27 PM
D Beals
 
Posts: n/a
Default

I did what you said and the dates still appear out of order. I created a
pivot table for daily quotes. When I update the pivot table all of the dates
are ascending except for some reason 5/14/2005 keeps coming up as the last
date in the table.

"D Beals" wrote:

My pivot table data is appearing with the dates out of order. How do I get
the dates to appear in order?

1/1/05 1st date
1/5/05 2nd date
1/2/05 third date

  #3   Report Post  
Old May 18th 05, 05:27 PM
Gary Brown
 
Posts: n/a
Default

Right click on the date field within the Pivot Table.
Select 'Field Settings'
Select 'Advanced'
Under 'AutoSort Options', select 'Ascending'.
HTH,
--
Gary Brown



"D Beals" wrote:

My pivot table data is appearing with the dates out of order. How do I get
the dates to appear in order?

1/1/05 1st date
1/5/05 2nd date
1/2/05 third date

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, vba or ??? chris Excel Discussion (Misc queries) 0 April 12th 05 04:19 AM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
Start & End Dates in pivot table AngePaton Excel Discussion (Misc queries) 0 January 4th 05 11:01 AM
pivot table in data source order Murray Excel Discussion (Misc queries) 1 December 24th 04 09:01 PM


All times are GMT +1. The time now is 04:21 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017