| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct order of months in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table row field order | Excel Discussion (Misc queries) | |||
| Pivot Table out of order | Excel Discussion (Misc queries) | |||
| pivot table column order | Excel Discussion (Misc queries) | |||
| pivot table dates are out of order how do I correct them | Excel Worksheet Functions | |||
Hybrid Mode
