My "Rows" field in my pivot table is in the format "DD/MM/YY HH:MM:SS" and my X-axis is showing the numeric formats that Excel stores rather than the "DD/MM/YY HH:MM:SS" format (i.e. 1/23/18 4:20:32 PM" shows as 43123.6809259259."). I have read about 20 different articles online and nothing has worked. My version of Excel is 2016. Any advice is beyond appreciated.