Ask Your Question

Bizarre dates in X-axis of chart [closed]

asked 2014-05-08 21:56:52 +0200

Kevin Krumwiede gravatar image

updated 2014-05-08 21:57:24 +0200

I'm trying to create a XY (Scatter) chart from two simple columns of data. Column A is formatted as dates. The values I have input are being interpreted as dates and not text. When I change the cell formatting, the dates all reformat as expected.

Column A is supposed to be the X values for my chart. The chart's range for X values defaulted to $Sheet1.$A$1:$A$11, which seems to be correct. But the X values on the chart have no obvious relationship to the data. They're not even in a sensible order. The first three values in the cells are 12/24/13, 12/31/13, and 1/12/14. The first three values in the chart are 9/6/92, 4/2/57, and 10/27/04!

What the heck is going on?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-22 10:55:29.165780

1 Answer

Sort by » oldest newest most voted

answered 2014-05-08 22:09:22 +0200

Kevin Krumwiede gravatar image

I discovered what was happening, but I don't know how it happened. My date column was formatted M/D/YY. In one cell, I entered the date 2/1/14. Somehow that was interpreted as 2/1/214 instead of 2/1/2014.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-08 21:56:52 +0200

Seen: 931 times

Last updated: May 08 '14