Excel Scatter Plot with Date on Horizontal Axis Not Displaying Properly

Question

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

Answer 1

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.

Answer 2

You can also check this link.

https://support.office.com/en-us/article/displa...

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

Thanks.

Answer 3

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.

Answer 4

Hi try using Line Chart instead of Scatter Plot.

thanks.

Answer 5

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.