| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart Dates not in correct order
I have a pivot table that has a week ending column and the date of 7/10/09 is
coming up before 7/3/09. Can you tell me how to get this in the correct order? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Chart Dates not in correct order
Right-click the field button, advanced, sort ascending.
Alterntively, you may have text that looks like dates, instead of true dates (stored as numbers), in which case you would need to modify your source data. (DATEVALUE function will help) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ls" wrote: I have a pivot table that has a week ending column and the date of 7/10/09 is coming up before 7/3/09. Can you tell me how to get this in the correct order? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Chart Dates not in correct order
Same way as in your other question. One thread will do.
-- David Biddulph "ls" wrote in message ... I have a pivot table that has a week ending column and the date of 7/10/09 is coming up before 7/3/09. Can you tell me how to get this in the correct order? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Chart Dates not in correct order
The suggestion to Right-click the field button, advanced, sort ascending
worked very well. Thank you. "Luke M" wrote: Right-click the field button, advanced, sort ascending. Alterntively, you may have text that looks like dates, instead of true dates (stored as numbers), in which case you would need to modify your source data. (DATEVALUE function will help) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ls" wrote: I have a pivot table that has a week ending column and the date of 7/10/09 is coming up before 7/3/09. Can you tell me how to get this in the correct order? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| inconsistent order of dates on pivot axis | Excel Discussion (Misc queries) | |||
| correct order of months in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Chart won't save order change of data | Excel Discussion (Misc queries) | |||
| pivot table dates are out of order how do I correct them | Excel Worksheet Functions | |||
Linear Mode
