Hi guys, so issue I have is.
I am pulling down some data from an external system into excel, which I turn into a pivot table and a chart. However the dates wont show in the correct order.
for example the data looks like this
29/02/2020, 28/02/2020, 27/02/2020, 26/02/2020, 25/02/2020, 22/02/2020, 21/02/2020, 20/02/2020, 19/02/2020
18/02/2020, 15/02/2020, 14/02/2020, 13/02/2020, 07/03/2020, 06/03/2020, 05/03/2020, 04/03/2020, 03/03/2020
No matter what I try (sorting, etc) I cant get then to run chronologically such as 03/03/2020, 04/03/2020 they just display like they are listed. Because I am pulling the data I don't really want to manipulate it to much.
Bookmarks