Pivot Table and Pivot Table dates are not in correct order
 

I have a pivot table that has a date field that is coming up out of order.
The column is labeled week ending data and the week of 7/10/09 is coming up
before 7/3/09. I need to get this back in line because it is throwing my
charts off. Can you tell me what to do to correct it.

Pivot Table and Pivot Table dates are not in correct order
 

It looks as if you haven't got a date field, but you've got text.
You'll need to change the text to dates. The archives of this group will
tell you how.
--
David Biddulph


"ls" wrote in message
...
I have a pivot table that has a date field that is coming up out of order.
The column is labeled week ending data and the week of 7/10/09 is coming
up
before 7/3/09. I need to get this back in line because it is throwing my
charts off. Can you tell me what to do to correct it.

Pivot Table and Pivot Table dates are not in correct order
 

Thanks David. I have date field specified in the M/DD/YY format. The dates
are in order for the months earlier in the year but fell out of order with
7/10/09 before 7/3/09. I have changed the date format to several different
formats and it didn't help. I checked my source data and the data formats in
the pivot table and pivot chart.

"David Biddulph" wrote:

It looks as if you haven't got a date field, but you've got text.
You'll need to change the text to dates. The archives of this group will
tell you how.
--
David Biddulph


"ls" wrote in message
...
I have a pivot table that has a date field that is coming up out of order.
The column is labeled week ending data and the week of 7/10/09 is coming
up
before 7/3/09. I need to get this back in line because it is throwing my
charts off. Can you tell me what to do to correct it.

Pivot Table and Pivot Table dates are not in correct order
 

You are not interested in the *display format*; you are interested in the
*cell content*.

Look at =ISTEXT(cell_ref) and =ISNUMBER(cellref).
If it is a real Excel date, these will be FALSE and TRUE respectively; if
it is text, these will give TRUE and FALSE respectively.
--
David Biddulph

"ls" wrote in message
...
Thanks David. I have date field specified in the M/DD/YY format. The dates
are in order for the months earlier in the year but fell out of order with
7/10/09 before 7/3/09. I have changed the date format to several different
formats and it didn't help. I checked my source data and the data formats
in
the pivot table and pivot chart.

"David Biddulph" wrote:

It looks as if you haven't got a date field, but you've got text.
You'll need to change the text to dates. The archives of this group will
tell you how.
--
David Biddulph


"ls" wrote in message
...
I have a pivot table that has a date field that is coming up out of
order.
The column is labeled week ending data and the week of 7/10/09 is
coming
up
before 7/3/09. I need to get this back in line because it is throwing
my
charts off. Can you tell me what to do to correct it.