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?