Excel only sees my dates as numbers, regardless of formatting. Help!

Occasional Visitor

Hello everyone!

 

I am experiencing an extremely frustrating issue which I'm hoping someone can help me with. I'm attempting to create a scatter plot with the x-axis showing dates of every 3 months (ex: January 2022, April 2022, July 2022, etc). However, Excel is only viewing my date field values as numbers instead of dates. Because of this, I don't have the option to change the axis type per Microsoft's instructions. Instead, my axis options appear like this:

 

Axis Options.PNG

 

And my scatter plot appears like this:

 

 Scatter Example.PNG

 

The date field I am using is formatted as a date which is why this is so frustrating. Things I've tried so far:

 

  • Changing the date format in the original field
  • Creating a new field and calculating the date as text with =TEXT([datefield], "MM/DD/YYYY")
  • Creating a new field and formatting the date like "Wednesday, March 14, 2022"
  • Creating a new scatter plot and reselecting each of these new fields

None of these things have helped. If anyone has any suggestions, it would be greatly appreciated. Thank you!

1 Reply

@TransportationPerson But date ARE numbers. Day number 1, being 1 January 1900. So, today (21 July 2022) we are on day 44763. What exactly are you trying ti do? Can you upload/share a file?