Menu

pivot table dates are out of order how do I correct them

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Gary Brown

Posts: n/a

Default

Are some of your dates in the original data actually text?
--
Gary Brown

"D Beals" wrote:

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 05:20 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement