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-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.

    Was this answer helpful?

    100+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-03-10T02:50:37+00:00

    Yes, I did that which is why the axis is in date format, but the dates are all incorrect. I checked the link you sent me, and my axis options are not in date form. The bounds are from 0 to 3000 and the units are major 500 and minor 100. Display units only has powers of ten.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2020-03-10T03:34:55+00:00

    A lot of forums discussed a line chart but I want specifically a scatter plot because I'm not examining trends over time but specific values at certain dates. Not to mention possible overlapping dates.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  4. Anonymous
    2020-03-10T03:29:52+00:00

    Hi try using Line Chart instead of Scatter Plot.

    thanks.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  5. Anonymous
    2020-03-10T02:02:55+00:00

    Hi, I am Joan an Independent Advisor and a Microsoft user hoping to help you today. i'm sorry if you're experiencing this problem.

    Can you try this:

    -Right click the Date on your Scatter Plot

    -click Format Axis

    -click Number on the left Pane

    -Change the Category, Type and Format Code of Date.

    I hope i helped you with this. Let me know if you need further assistance.

    Thanks.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments