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?
|