Share via

Excel Scatter Plot with Date on Horizontal Axis Not Displaying Properly

Anonymous
2020-03-09T23:42:02+00:00

Title exactly. The released column's cells are formatted as dates, but for some reason the horizontal axis on the scatter plot is starting at 1900. (Image is old, but even changing the x axis to match the same date formatting of yyyy-mm-dd does not fix anything.)

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

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-10T03:42:56+00:00

    I apologize , I don't have any solution for you as of now. I hope another expert can help you to resolve your problem.

    0 comments
  2. Anonymous
    2020-03-10T13:32:07+00:00

    I figured it out and wanted to let you know since you tried to help me out. The date information was stored as text because it came from a database. When I formatted the cells to date, I assumed Excel understood my intentions, but it never actually converted the cells to the date format. To fix it, I used the =VALUE() function in another column for each cell, then formatted the new column as date. Presto. Problem solved. Thank you.

    103 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-03-10T13:34:02+00:00

    I’m glad you made it!

    1 person found this answer helpful.
    0 comments