SOLVED

Strange Dates Showing Up in Graph

Copper Contributor

Hey,

So recently I've been working on analytical data, but I've run into a strange problem during graphing. My data is organized by the date, so when I go to graph I try to graph with that. The problem is is that no matter what I do it puts the wrong dates into the axis. My data is from 1/16/1995-12/16/2014 but it puts the axis at 1/0/1900-10/26/1900. I've tried converting the numbers, tried messing with the number bit on the axis options, but nothing works. Please help.

3 Replies

@JessicaMeyer 

I need a sample excel file to help you

best response confirmed by JessicaMeyer (Copper Contributor)
Solution

@JessicaMeyer 

As variant dates are not added as X axis, thus you have sequential numbers instead.

image.png

If you apply Date format to axis it'll be like

image.png

since dates are just numbers starting from 1 which is equal to Jan 01, 1900.

@SergeiBaklan I was hoping to not have to do that because other graphs I have have worked without doing the numbers, but I gave up and figured out the numbers for each date.

1 best response

Accepted Solutions
best response confirmed by JessicaMeyer (Copper Contributor)
Solution

@JessicaMeyer 

As variant dates are not added as X axis, thus you have sequential numbers instead.

image.png

If you apply Date format to axis it'll be like

image.png

since dates are just numbers starting from 1 which is equal to Jan 01, 1900.

View solution in original post