Share via

Dates within Months of Pivot Table not sorting properly.

Anonymous
2020-07-20T15:42:25+00:00

I am working on a pivot table and I thought I had everything perfect. It was grouping by months great and showing all the dates, but then I looked at my dates and inside each month the dates were not sorted properly. Here's what it looks like:

As you can see, the dates are not in proper order. The months are in the right order, but the dates within the months are not in the correct order.

Anyone know how I can fix this? It's throwing off my entire line chart.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-07-20T21:44:50+00:00

    Hi iamjmw,

    As per your description, you just click on cell>go to data tab>click sort>select ascending order to sort your dates correctly.

    For reference: Sort data in a PivotTable

    If you still cannot be able to correct sort order, and if it is convenient for you, could you please share with us your Excel file and I will help you to sort in proper order. You can provide the requested files in private message. Please click here  to access your PM.

    I appreciate your time and understanding.

    Best Regards

    Waqas Muhammad

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-22T21:26:58+00:00

    Hi iamjmw,

    Feel free to post back if you need further assistance.

    Best Regards,

    Waqas Muhammad

    0 comments